Postgres 18 | Postgres.FM 160 |
[ 🇬🇧_🇺🇸 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...
Postgres 18 release notes https://www.postgresql.org/docs/18/re...
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...
pganalyze Index Advisor https://pganalyze.com/index-advisor
BUFFERS by default https://postgres.fm/episodes/buffers-...
Buffers II (the sequel) https://postgres.fm/episodes/buffers-...
Return of the BUFFERS https://postgres.fm/episodes/return-o...
UUID https://postgres.fm/episodes/uuid
Partitioning by ULID https://postgres.fm/episodes/partitio...
uuidv7 and uuid_extract_timestamp functions https://www.postgresql.org/docs/curre...
Add --no-policies option to pg_dump, pg_dumpall, and pg_restore https://git.postgresql.org/gitweb/?p=...
Add ONLY support for VACUUM and ANALYZE https://git.postgresql.org/gitweb/?p=...
Make "vacuumdb --analyze-only" process partitioned tables (committed recently for Postgres 19) https://commitfest.postgresql.org/pat...
NOT VALID constraints https://postgres.fm/episodes/not-vali...
The year of the Lock Manager’s Revenge (post by Jeremy Schneider) https://ardentperf.com/2024/03/03/pos...
Increase the number of fast-path lock slots https://git.postgresql.org/gitweb/?p=...
"enable" parameters will work differently in Postgres 18 https://www.pgmustard.com/blog/enable...
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 / postgresfm , @samokhvalov / samokhvalov and @michristofides / 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.
On this page of the site you can watch the video online Postgres 18 | Postgres.FM 160 | with a duration of hours minute second in good quality, which was uploaded by the user PostgresTV 01 January 1970, share the link with friends and acquaintances, this video has already been watched 1,109 times on youtube and it was liked by 43 viewers. Enjoy your viewing!
