--- title: "Postgres 18 enters the Release Candidate stage" publication: "Postgres Weekly" issue: 614 published_at: "2025-09-04" canonical_url: "https://postgresweekly.com/issues/614" --- Plus a recurring schedule extension, some time travel, and a new way to import CSVs. | #​614 — September 4, 2025 [Web Version](https://postgresweekly.com/issues/614) Together with [![Redgate\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_800,h_192/e_make_transparent/co_white,e_outline:9/juuaxaie2hv6pua7rl7k.png)](https://rd.gt/47Q0YbA) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/ae8g3cl11hcrttbzf870.jpg)](https://github.com/h4kbas/pgcalendar) 🗓️ [pgcalendar: 'Infinite' Calendar Functionality for Recurring Schedules](https://github.com/h4kbas/pgcalendar) — 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.](https://github.com/h4kbas/pgcalendar?tab=readme-ov-file#basic-usage-examples) Huseyin Akbas [A Quirk of Partitioned Table Statistics](https://www.cybertec-postgresql.com/en/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 [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/f375dba1.png)](https://rd.gt/3HTpfTC) [Monitor PostgreSQL with Confidence](https://rd.gt/3HTpfTC) — 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](https://rd.gt/3HTpfTC). Redgate sponsor **IN BRIEF:** - ⭐ Just as we were about to hit 'send', [Postgres 18 Release Candidate 1 has landed](https://www.postgresql.org/about/news/postgresql-18-rc-1-released-3130/) :-) While we're on the topic, Ahsan Hadi looks [at the highlights of Postgres 18](https://www.pgedge.com/blog/highlights-of-postgresql-18). - 🇱🇻 [PostgreSQL Conference Europe 2025](https://2025.pgconf.eu/) takes place in Riga, Latvia this October 21-24 and [the full talk schedule](https://www.postgresql.eu/events/pgconfeu2025/schedule/) is now live. - 🎤 [PG Down Under](https://pgdownunder.com/) is a Postgres podcast that's only just appeared on our radar. The latest episode features RedGate's Grant Fritchey talking about his work on the [pgNow](https://www.red-gate.com/products/redgate-pgnow/)tool. - The [PgDog](https://pgdog.dev/) Postgres sharder / routing layer has [added support for Rust-based plugins.](https://pgdog.dev/blog/plugins-are-back) [Optimizing Cold Page Reads in Postgres](https://www.pgedge.com/blog/optimising-cold-page-reads-in-postgresql) — 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](https://stormatics.tech/blogs/the-hidden-bottleneck-in-postgresql-restores-and-its-solution) Warda Bibi 📄 [Automated Postgres Backups in Docker: Complete Guide with `pg_dump`](https://serversinc.io/blog/automated-postgresql-backups-in-docker-complete-guide-with-pg-dump) Servers Inc. 📄 [Best Practices for Securing Postgres in Hybrid Environments](https://severalnines.com/blog/best-practices-for-securing-postgresql-in-hybrid-environments/) Sebastian Insausti (Severalnines) **RELEASES:** 🌐 [PostGIS 3.6.0 Released](https://postgis.net/2025/09/PostGIS-3.6.0/) — 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](https://emaj.readthedocs.io/en/latest/) — 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](https://github.com/PostgREST/pg_csv) — Designed to resolve some of the problems with `COPY`’s CSV support. PostgREST Team [Jailer 16.9: Database Subsetting and Relational Data Browsing Tool](https://github.com/Wisser/Jailer) — 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](https://github.com/tensorchord/VectorChord) – Scalable, fast, and disk-friendly vector search in Postgres. - [TimescaleDB 2.22](https://github.com/timescale/timescaledb/releases/tag/2.22.0) – Time series capabilities for Postgres in an extension. - [PostgREST 13.0.6](https://github.com/PostgREST/postgrest) – A REST API for any Postgres database. - [sqlc 1.30](https://github.com/sqlc-dev/sqlc/releases/tag/v1.30.0) – Generate type-safe Go code from SQL. **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **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. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*).