Benchmarks and analysis of running Postgres along with different Linux IO schedulers. Some background here.

Grouping (not in the SQL sense) some set of data into sets of activities is incredibly common when you want to reason about your data - here’s a great highlight of how to actually apply that from Periscope.

Datadog natively collects hundreds of Postgres metrics: system resources, connections, locks, transactions, indexes, and more. Pre-built, fully customizable visualizations, alerts, and full-stack performance correlation. 14 day unlimited trial.

A command line tool that generates markdown documentation for Postgres tables in a given schema.

Postgres connections are notoriously memory bloated, and the answer is generally a good connection pooler like PgBouncer. However, pgbouncer won’t solve all your problems, and here’s a great highlight of how you have to handle it with something like ActiveRecord.

A look at how some engineers migrated a legacy project from Mongo to Postgres, and some tips for doing it yourself.

GoCardless has created a library, ActiveRecord::SaferMigrations, that automatically sets lock_timeout and statement_timeout before running migrations to prevent them stopping your app from responding to requests.

Bruce Momjian has noticed Postgres going in multiple directions in terms of use-cases, including big data, data analytics, and NoSQL.

Indeed Prime is an elite new program from Indeed.com that presents in-demand tech talent like you to top employers. Indeed Prime opens the door to exciting career opportunities with one simple application. Join today!