#344 — February 26, 2020

Read on the Web

Postgres Weekly

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 BackupsHaving backups is one thing, but you also need to ensure they’re viable and ready to actually use.


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

▶  Digging into Postgres at a Low Level: Stay Curious — A ~40 minute talk from last year that, sadly, we forgot to include at the time. It goes deep into exploring how to use tools like strace and gdb to troubleshoot intricate performance issues. Most of you will never need to do these things, but it’s useful to know it’s possible.

Dmitrii Dolgov

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

🗓 Upcoming Events

  • Postgres Conference 2020 (March 23-27 in New York, United States) — A broad and large scale (indeed, the largest, they say) Postgres event.
  • Nordic PgDay 2020 (March 24 in Helsinki, Finland)
  • pgDay Paris 2020 (March 26 in Paris, France)
  • Swiss PGDay 2020 (June 18-19 in Switzerland) — A two track conference (one in English, one in German) aimed at the entire Postgres community.
  • Postgres Ibiza 2020 (June 25-26 in Ibiza, Spain) — A two day conference on the sunny island of Ibiza in the Mediterranean. I recall this one getting some great trip reports last year!

Running a Postgres related event that's beyond the scale of a small local meetup or user group? Let us know (just hit reply) and we can include it here in future issues.