~postgresweekly | Bookmarks (117)

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.

📊 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.

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.

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).

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.

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 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…

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.

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.

Data Archiving and Retention in Postgres — Daria presents her slides, along with explanations, from her talk at PGConf Germany where she covered best practices when working with large datasets. Lots of good tips in here.

Microsoft Unveils an IDE for Postgres in VS Code — Microsoft has unveiled a public preview of a new Postgres extension for its VS Code editor that lets you manage database objects, use IntelliSense to build queries, and integrate with Copilot too.

pgconf.dev 2025 Wraps Up with Great Success in Montreal — I’ve heard from numerous sources that last week’s PGConf.dev event was a raging success, and this is one of the most thorough writeups (complete with photos) I’ve ever seen of a Postgres event. Hopefully we’ll get to see some of the videos too in coming weeks.

Creating Short Alphanumeric Pseudorandom Identifiers — Suppose you need to create a readable and unique multi-character identifier to represent an ID, but without being as long as a UUID (think something like a YouTube video ID). PL/PgSQL to the rescue!

▶  Scaling Postgres: A Weekly Show about Postgres — For several years now, Creston has been producing a video a week where he digs into the latest Postgres news, articles, and so forth – much like us, but he gets to riff a little more and share his experiences and insights.

dblab: An Interactive Client for Postgres, MySQL, and More — A Go-powered cross-platform (yes, including Windows) TUI-style app for working with various database systems. Certainly looks different to the standard CLI clients.

PostgREST 13: A RESTful API for Postgres Databases — A standalone web server that turns your Postgres database directly into a RESTful HTTP API. v13.0 adds support for spread to-many relationships and automatic tsvector conversion allowing the use of fts on text and json types out of the box.

Vircadia: A Postgres-Powered Reactivity Layer for Games — It seems to be early days, but the idea is you can use Vircadia to simulate agentic worlds and manage in-game entities through SQL.

pgwatch 3.3: A Postgres Monitoring Solution — A self-contained metrics monitoring dashboard tool for Postgres servers. Can be easily deployed with Docker in a non-invasive way (no extensions needed). GitHub repo.

pgModeler 1.2: A Postgres Database Modelling Tool — An easy way to create and edit database models in a more visual way. It’s packaged up as a paid product but is also open source (GPLv3 – repo here) so you can build it yourself. v1.2 is a significant update.

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.

Postgres 18 Beta is Out: 7 Features You Should Know About — Last week’s big news was the release of Postgres 18 Beta 1. Neon has put together a quick roundup of seven features to be aware of.

Announcing pg_parquet v.0.4.0 — pg_parquet provides a way to export and import Parquet files directly within Postgres, without relying on third-party tools.

The Draft Release Notes for Postgres 18 — Bruce Momjian has just completed his first draft of the Postgres 18 release notes in time for Beta 1. The final release is expected in September or October.