Postgres is an amazing database when your active data fits in memory. If it doesn’t then you’re starting to look at a sizable dataset (greater than 100 GB) and at that point a little more care and effort may be required..
Over time, conditions change including data growth, usage patterns, and the amount of resources available to the database. Periodic tuning is the Postgres DBAs role to ensure that things continue to run smoothly. Learn how to optimize performance or get help with a database check up.
Sure, Postgres is a relational database but that doesn’t mean it doesn’t have the flexibility to work with key-value data. HStore is an awesome solution for that and it’s a built-in extension.
Working with Meteor because it’s a more responsive framework? Well Postgres can play well with it too using this latest package that brings reactive Postgres to Meteor.
Want an JSON Schema representation of your database with little to no effort? Here’s a simple and easy way to expose your Postgres DB schema directly in JSON Schema.
First covered just a few months ago in PG Weekly, there’s a nice update which is better production-ized for handling URIs in Postgres with a ready to use extension.
You love to hack Postgres? And C is more than the third letter of the alphabet for you? Join us as the PostgreSQL expert to help us administrate databases for real-time analytics over terabytes of mobile app data.
