Postgres provides a lot of flexibility with indexes, but you can end up with a result that isn’t ideal. Here’s a few Ruby and Rails-flavored tricks to help you make the right choice for your situation.

Compiled from multiple sources like the Postgres wiki and check_postgres.

A look under the covers at debugging an issue in Postgres around auto-vacuum. A good look for understanding what happens under the hood of Postgres.

In Compose PostgreSQL you can now perform cross-database queries using some extensions we've recently made available: postgres_fdw and dblink. In this article we'll walk through how to set up your database to take advantage of them.

Postgres’ listen/notify support (pub/sub) is a great option for a notification system. If you’re looking for a thorough walkthrough of what you can do, this is your guide.

EnterpriseDB is adding tools to its PostgreSQL distribution to challenge the big commercial databases.

WAL-E is one of, if not the, most popular tools for continous archiving the Postgres Write-Ahead-Log to S3. Here’s your perfect step-by-step guide in getting things setup.

DreamFactory auto-generates APIs and enables data and service bundling across multiple servers and DBs. Supports V8, Node.js, PHP, and Python for custom scripting.

Postgres like so many developer tools isn’t always portable, but that doesn’t have to be the case. This simple guide lays out whats actually stored where and how you can better move things around.

Composite types in Postgres can be extremely powerful, but not all frameworks are so friendly in working with them. Fortunately Django just got a bit friendlier..

This minor release introduces support for ‘–peek’ option and for the ‘get-wal’ command which allows users to implement parallel remote restore commands on standby servers and during recovery.

Indeed Prime connects top tech talent with top tech companies in the US. Companies compete to hire developers on Indeed Prime. 100% free for job seekers. Land a job and get $5k from Indeed Prime.