Postgres Replication Slots: Confirmed Flush LSN vs. Restart LSN — Replication slots keep Postgres from discarding WAL (Write-Ahead Log) segments till all consumers have read them. Consumers track progress via log sequence numbers (LSNs), but Postgres exposes multiple LSNs with subtly different meanings. Gunnar Morling explains their differences, as well as why both matter in production.

Gunnar Morling

Spot and Fix PostgreSQL Schema Drift Fast — Tired of schema surprises? pgCompare shows you exactly what changed between environments, down to the SQL line. Quickly generate scripts to sync changes and fix issues fast. Available free for non-commercial use. Check it out.

Redgate sponsor

No, You Don't Necessarily Need Extensions to Compact Postgres Tables — Let’s say you can’t use pg_squeeze or pg_repack on your server, what can you do to reduce bloat in a large table without a full vacuum? Kaarel offers an approach.

Kaarel Moppel

High Availability and Postgres Full-Sync Replication — Multigres is a project to build an adaptation of Vitess for Postgres for multi-tenant, highly available scaling. In this post the creator of both Multigres and Vitess explains the issues involved and how they plan to tackle them.

Sugu Sougoumarane

pg_squeeze 1.9: Extension to Automate Table Bloat Cleanup — While not a replacement for vacuuming, this extension goes a step further to gain even more space improvements in-situ and now supports Postgres 18.

CYBERTEC

plpgsql_check 2.8.2: A PL/pgSQL Code Checker — A specialized tool for when you want to find any errors lurking in your PL/pgSQL functions.

Pavel Stehule

How Instacart Built a Modern Search Infrastructure on Postgres — Somehow we missed it when it was posted back in May, but this is a neat look at how a popular grocery delivery/pickup service shifted its full text search approach from Elasticsearch to Postgres while introducing semantic and hybrid search elements.

Ankit Mittal et al. (Instacart)