A look at two useful tricks that, the author claims, even ‘power users find surprising’: disabling JOIN re-ordering and using arrays with LIKE.

Indexes tend to make queries fast, but they come at a cost of write throughput. Read how Citus, a Postgres extension, can help parallelize queries to speed things up.

After 14 years, Josh Berkus, long time contributor and core team member, has stepped down from the Postgres core team and wants to encourage fresh leadership for the project.

Visualize and alert on system resources, connections, locks, transactions, and indexes for real-time full-stack performance monitoring.

A number of potential ways to improve your PG backups.

Table inheritance if often equated with partitioning in Postgres, but as highlighted here can be used from more traditional CS object inheritance if you so choose.

Under the covers Postgres is one giant append-only log, which in correct technical terms is the write-ahead-log. Here you can find an overview of what it is and how to work with it.

Develop apps faster. DreamFactory automatically turns Postgres into a REST API platform in minutes.