shared_buffers: Looking Into Postgres's I/O Cache — Simply, the shared_buffers config setting lets you specify how much memory is used for caching data, but the default value of 128 megabytes is relatively low (so it’s common to increase this value). Here’s a look at what the cache does and contains.

Hans-Jürgen Schönig

An Eye on the Locks of PostgreSQL — Within database systems, locks prevent simultaneous access (or manipulation) of data that’s already in use or being changed. Postgres supports numerous types of lock, like table locks, row locks, transaction locks, and more. This post takes a deeper look at them.

Movead Li

Track Key PostgreSQL Performance Metrics in Real Time — Identify slow-running queries, bottlenecks, error rates and more in seconds with drag-and-drop, customizable dashboards to ensure your database can scale sufficiently. Elevate PostgreSQL performance, get started free with Datadog.

Datadog sponsor

On the Automated Testing of Postgres Backups — Having backups is one thing, but you also need to ensure they’re viable and ready to actually use.

RapidLoop

Postgres Parallelism, What Next? — A brief look at the journey of parallelism in PostgreSQL from 9.6 until now.

Amit Kapila

Preparing Your Postgres Data for Scale-Out — As your app’s popularity grows, how should you prepare for the growth in usage of your Postgres instance?

Matthew Revell

Why I’m Not A Fan of the uuid Datatype — UUIDs have both pros and cons over standard sequential keys. This post solely focuses on performance, but the comments help balance things out.

Hubert depesz Lubaczewski

Connecting to Azure PostgreSQL with libpq 12 in a Kerberos Environment

Magnus Hagander

Faster CI/CD for All Your Software Projects Using Buildkite — See how Shopify scaled from 300 to 1500 engineers while keeping their build times under 5 minutes.

Buildkite sponsor

PostGIS 3.0.1: Geospatial Objects for Postgres — It might only be a x.0.1 release, but it’s the first after PostGIS’s move to git and it also supports the current edge Postgres 13 builds if you need that.

PostGIS Developers

rails-pg-extras: Postgres Database Insights for Ruby and Rails — Ruby on Rails developer? This plugin lets you get quick info about locks, index usage, buffer cache hit ratios, vacuum stats and more. There’s a pure Ruby (non Rails) version too.

Paweł Urbanek