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:
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 via a YouTube comment, on social media, or by commenting on our Google doc!
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
~~~
Postgres FM is produced by:
- Michael Christofides, founder of pgMustard
- Nikolay Samokhvalov, founder of Postgres.ai
With credit to:
- Jessie Draws for the elephant artwork
