Postgres Weekly
Plus a recurring schedule extension, some time travel, and a new way to import CSVs. |

#​614 — September 4, 2025

WebĀ Version

Together withĀ  Redgate

Postgres Weekly

šŸ—“ļøĀ pgcalendar: 'Infinite' Calendar Functionality for RecurringĀ Schedules — If you need to store schedules for events, potentially with exceptions (like holidays or cancellations), this extension provides a way to model those concepts. Examples.

Huseyin Akbas

A Quirk of Partitioned Table Statistics — Postgres relies on partitioned table stats to estimate join row counts, but autovacuum won’t collect them, meaning you need to run ANALYZE explicitly for goodĀ plans.

Laurenz Albe

Monitor PostgreSQL with Confidence — Redgate Monitor gives you real-time insights, intelligent alerts, and deep diagnostics for your PostgreSQL databases. Stay ahead of performance issues and keep your systems running smoothly. Explore RedgateĀ Monitor.

Redgate sponsor

IN BRIEF:

Optimizing Cold Page Reads in Postgres — Useful tuning tips if your apps have non-traditional access patterns that don’t benefit fromĀ caching.

Tej Kashi

šŸ“„ The Hidden Bottleneck in Postgres Restores and its Solution Warda Bibi

šŸ“„ Automated Postgres Backups in Docker: Complete Guide with pg_dump Servers Inc.

šŸ“„ Best Practices for Securing Postgres in Hybrid Environments Sebastian Insausti (Severalnines)

RELEASES:

🌐 PostGIS 3.6.0 Released — The popular extension for adding powerful geospatial data processing support to Postgres now targets Postgres 18 (currently atĀ RC1).

PostGIS PSC and OSGeo

E-Maj 4.7: Fine-Grained Write Logging and Time Travel Extension — An extension that traces updates performed on tables which can then be used to perform ā€˜time travel’ on subsets of your database. v4.7 brings Postgres 18 support, including support for virtual generated columns. (TIL E-Maj stands for ā€œEnregistrement des Mises Ć  Jourā€, that is ā€œrecording ofĀ updatesā€.)

Philippe Beaudoin

pg_csv: Flexible CSV Processing Extension — Designed to resolve some of the problems with COPY’s CSVĀ support.

PostgREST Team

Jailer 16.9: Database Subsetting and Relational Data Browsing Tool — Navigate bidirectionally through databases by following foreign-key-based or user-defined relationships. Built in Java and supports most relational databases viaĀ JDBC.

Wisser

  • VectorChord 0.5.1 – Scalable, fast, and disk-friendly vector search inĀ Postgres.

  • TimescaleDB 2.22 – Time series capabilities for Postgres in an extension.

  • PostgREST 13.0.6 – A REST API for any PostgresĀ database.

  • sqlc 1.30 – Generate type-safe Go code fromĀ SQL.

Issue 613 #614 Issue 615