Postgres 18 & 160 | PostgreSQL Podcast 🎧

[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]

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


~~~


What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm https://twitter.com/PostgresFM, @samokhvalov https://twitter.com/samokhvalov and @michristofides https://twitter.com/michristofides


~~~


Postgres FM is produced by:
- Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
- Michael Christofides, founder of pgMustard https://pgmustard.com/


~~~


This is the video version. Check out https://postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.