#ā614 ā September 4, 2025 |
|
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 š 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 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 |
|
|
Got a new email? You can change your address here. Bored of us? Click here to stop getting Postgres Weekly. Got a link for us? Reply and tell us. We can't include everything but we'll look at anything you send. Thanks! Published by Cooper Press Ltd. Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. |

