~postgresweekly | Issue 602 - Postgres config settings for humans (10)

Why Upgrade Postgres? Here's Why — A perennially useful resource that lets you pick ‘from’ and ‘to’ versions and see what Postgres gained in the interim. Even this 17.4 to 17.5 example is packed with details.

How OpenAI Scales Postgres to the Next Level — A writeup of a talk given by OpenAI engineer Bohan Zhang at PGConf.dev about how OpenAI manages to scale with an unsharded approach using just one writer and multiple readers despite Postgres being ‘the backbone of [its] most critical systems’. If it’s good enough for them…

PostgresqlCO.NF: Postgres Config Settings for Humans — A helpful online reference guide to Postgres’ various parameters from basics like log_statement and application_name through to things added in the very latest versions (including v18, currently in beta).

Using pg_test_fsync for Testing Low Latency Writes — pg_test_fsync is a tool that comes with Postgres for determining the fastest wal_sync_method option to use on your hardware.

Debugging Memory Leaks in Postgres via Heaptrack — A Linux-only walk through an artificial example of introducing memory leaks into Postgres and then debugging them using the heaptrack memory profiler.

How to Run Cron Jobs in Postgres Without Extra Infrastructure — pg_cron might be your go-to if you want to keep everything in Postgres itself, but if you’re building a Node app (such as with Wasp, as in this tutorial) then the pg-boss job queue offers an alternative option.

A Dockerfile to Build Postgres 18 Beta from Source — A handy way to get playing with Postgres 18 beta 1 quickly, since betas don’t get official container images.

📊 PG Exporter 1.0: Advanced Postgres + Pgbouncer Metrics Exporter for Prometheus — Exposes 600+ metrics covering core internals as well as popular extensions, all through a single, fully customizable exporter. v1.0 offers some initial Postgres 18 support too.

pgfdb: Making Postgres Distributed with FoundationDB — pgfdb is an experimental extension to turn Postgres into a stateless layer that sits atop FoundationDB, a distributed, multi-model data store.

POSETTE 2025: Save the Date! — POSETTE: An Event for Postgres, a free & virtual developer event, is less than a month away -- June 10-12. Learn from 45 experts from the PostgreSQL ecosystem. Choose from 42 unique talks via 4 livestreams with live chat on Discord. Save the date.