Making the Postgres Visibility Map Visible — If you’ve never gone far down the Postgres performance or transactions rabbit hole, you may have never encountered the visibility map. It’s a mechanism by which Postgres tracks which pages of a table contain only tuples that are visible to all transactions. This has some performance implications.

Laurenz Albe

A Mentoring Program for Postgres Contributors — Prolific Postgres contributor Robert Haas is starting a mentoring program where people who want to contribute code to Postgres can be mentored by current committers. It’s only open to nine people so far, but this is a great opportunity for anyone interested.

Robert Haas

Render Is Your Fastest Path to Production — Whatever your stack you can build, deploy quickly, update and confidently scale your apps with ease, from the first to the billionth user. Start building with Render for free — the modern cloud for devs.

Render sponsor

Custom ENUM Type Columns and ORDER BY — Enumerated types make it easy to enforce constraints on what can go in certain columns, but you might need to take care when ordering them.

Christoph Schiessl

A Post-Mortem of Some Postgres 'Out of Shared Memory' Errors — Too many locks spoil the broth.

Andrea Baida

An Introduction to Generated Columns in Postgres — In Postgres, generated columns are columns that are automatically populated based upon the result of a user-defined expression when rows are inserted or updated.

Craig Hafer

Load from Postgres to Postgres Faster via DuckDB — How to export and import data from Postgres to Postgres in a fast way with ConnectorX and DuckDB.

Simon Späti

pgModeler: 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.

Raphael Araújo e Silva

The Dalibo Postgres Execution Plan Visualizer — Give this the output from EXPLAIN ANALYZE and get a better view at what Postgres plans to do with your query. It’s also open source if you want to use it locally or within an app.

Dalibo

pg_squeeze: Extension to Automate Table Bloat Cleanup — While it’s not a replacement for vacuuming, it’s a handy extension to go a step further and gain even more space improvements in-situ.

CYBERTEC

pspg: A Unix Pager Designed for Postgres Tables — If you use psql you probably use less as your pager, but it doesn’t directly support tabular data. This does. Nowadays, it also supports MySQL, CSV and TSV too.

Pavel Stehule

pg_easy_replicate: Switch Databases with Minimal Downtime — A Ruby-powered orchestrator to simplify the task of setting up logical replication between two Postgres databases then letting you switch over to the newer one with minimal downtime.

Shayon Mukherjee