Postgres 18

Nik and Michael discuss the newly released Postgres 18 — the bigger things it includes, some of their personal highlights, and some thoughts towards the future.

Here are some links to things they mentioned:
• Postgres 18 announcement postgresql.org/about/news/postgresql-18-releas…
• Postgres 18 release notes postgresql.org/docs/18/release-18.html
• Skip scan episode with Peter Geoghegan postgres.fm/episodes/skip-scan
• Easier Postgres fine-tuning with online_advisor neon.com/blog/easier-postgres-fine-tuning-with…
• pganalyze Index Advisor pganalyze.com/index-advisor
• BUFFERS by default postgres.fm/episodes/buffers-by-default
• Buffers II (the sequel) postgres.fm/episodes/buffers-ii-the-sequel
• Return of the BUFFERS postgres.fm/episodes/return-of-the-buffers
• UUID postgres.fm/episodes/uuid
• Partitioning by ULID postgres.fm/episodes/partitioning-by-ulid
• uuidv7 and uuid_extract_timestamp functions postgresql.org/docs/current/functions-uuid.html
• Add --no-policies option to pg_dump, pg_dumpall, and pg_restore git.postgresql.org/gitweb/?p=postgresql.git;a=…
• Add ONLY support for VACUUM and ANALYZE git.postgresql.org/gitweb/?p=postgresql.git;a=…
• Make "vacuumdb --analyze-only" process partitioned tables (committed recently for Postgres 19) commitfest.postgresql.org/patch/5871
• NOT VALID constraints postgres.fm/episodes/not-valid-constraints
• The year of the Lock Manager’s Revenge (post by Jeremy Schneider) ardentperf.com/2024/03/03/postgres-indexes-par…
• Increase the number of fast-path lock slots git.postgresql.org/gitweb/?p=postgresql.git;a=…
• "enable" parameters will work differently in Postgres 18 pgmustard.com/blog/enable-parameters-work-diff…
• logerrors github.com/munakoiso/logerrors

~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (postgres.fm/people) or by commenting on our Google doc (docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6…)!

~~~
Postgres FM is produced by:
• Michael Christofides, founder of pgMustard (pgmustard.com)
• Nikolay Samokhvalov, founder of Postgres.ai (postgres.ai)

With credit to:
• Jessie Draws for the elephant artwork