📅 If you're looking for a Postgres event to attend, check out the list at the end of this issue. So many have popped up on my radar recently, I wanted to share as many as I could. If you know of any others, drop me a line! __ Your editor, Peter Cooper |
What’s New in the Postgres 16 Query Planner / Optimizer — Query planner improvements rarely make the headlines when a new release of Postgres lands, but Postgres 16 gained some significant improvements that are enhancing all of our queries today. David walks through ten recent optimizations, complete with Postgres 15 vs 16 query plans, and shows us how and when things have improved.
David Rowley
|
Auto Optimize Your RDS or Aurora Postgres Databases With AI — Need help optimizing Postgres knobs, queries, indexes and autovacuum? OtterTune is your AI-powered database co-pilot that can improve performance, reduce costs and keep your databases healthy. Get a free, 30-day trial for three databases.
OtterTune
|
PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 Released — All supported versions get updates to fix a variety of bugs, as well as a security vulnerability where the owner of a materialized view could get a higher privileged user to run code associated with that view at their higher level (now all user-determined code is run as the view’s owner, as it’s meant to be).
PostgreSQL Global Development Group
|
-
TimescaleDB 2.14.0 – Time series capabilities for Postgres in an extension. This version lets you change the compression settings on existing compressed hypertables at any time.
-
PostGIS patch releases: v3.4.2, 3.3.6, 3.2.7, 3.1.11, 3.0.11, and 2.5.10.
|
🗓 Upcoming Events
- 🇫🇷 pgDay Paris 2024
(March 14) — You can follow them on Twitter or on Mastodon for updates.
- 🇺🇸 PostgreSQL@SCaLE21x
(March 14-15) — A two day, two track event that takes place in Pasadena, California, as part of SCaLE 21x.
- 🇻🇳 PGDay at FOSSASIA Summit
(April 9) — FOSSASIA PGDay 2024 takes place in Hanoi, Vietnam, as part of the broader FOSSASIA Summit.
- 🇩🇪 PostgreSQL Conference Germany 2024
(April 12) — The next iteration takes place in Munich.
- 🇺🇸 Postgres Conference 2024 (April 17-19) — Taking place in San Jose, California. The CFP is open for just a few more days!
- 🇺🇸 PGDay Chicago 2024
(April 26) — Part of a non–profit, community–run conference series. The schedule has just been unveiled.
- 🇧🇪 PGConf.BE 2024
(May 7) — In Haasrode, Belgium. Their call for speakers is open.
- 🇨🇦 PostgreSQL Development Conference 'pgconf.dev' 2024
(May 28-31) — This year in Vancouver, Canada.
- 🌎 POSETTE
(June 11-13) — Formerly known as Citus Con, POSETTE is a free and virtual developer event organized by the Postgres team at Microsoft.
- 🇨🇭 Swiss PGDay 2024
(June 27-28) — Two day conference with presentations mainly in English, but also some in German.
- 🇺🇸 PGConf NYC 2024
(September 30-October 2) — A 3-day conference in New York City, promising to be packed with user stories and best practices. The CFP is open until June.
|
|
|