Minor releases | Postgres.FM 097 |

[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try UA-cam's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Nikolay and Michael discuss Postgres minor releases - how the schedule works, options for upgrading to them, and the importance of reading the release notes.
Here are some links to things they mentioned:
* PostgreSQL 16.3, 15.7, 14.12, 13.15, and 12.19 released (announcement) www.postgresql.org/about/news...
* PostgreSQL versioning policy www.postgresql.org/support/ve...
* PostgreSQL 14.4 release notes (most recent minor release not on the usual schedule) www.postgresql.org/docs/relea...
* Minor release roadmap www.postgresql.org/developer/...
* Our last episode on upgrades (major and minor) postgres.fm/episodes/upgrades
* All versions of Postgres bucardo.org/postgres_all_vers...
* Why upgrade? (Useful tool by depesz) why-upgrade.depesz.com/
* Stop and start Postgres faster postgres.fm/episodes/stop-and...
* WAL and checkpoint tuning postgres.fm/episodes/wal-and-...
* Postgres CVE-2024-4317 and how to fix the system views (5 mins of Postgres by Lukas Fittl) • Postgres CVE-2024-4317...
* Our episode on NULL postgres.fm/episodes/nulls-th...
* What should we do for episode 100? / what_should_we_do_for_...
~~~
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 brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai postgres.ai/
- Michael Christofides, founder of pgMustard pgmustard.com/
~~~
This is the video version. Check out postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.

[@kirkwolak6735]

Yes, you should test with your extensions. You should have a few general procedures you run that exercise using all of the extensions. And you should monitor log sizes. In case something is going wrong, and it's only in the log files.
I like using htop in linux, and watching how much memory the various threads are using and the total. In case memory consumption has changed... This can lead to issues.
Reading the documentation for the release. YES, it is good documentation. But it can feel a bit overwhelming because they document so much...

[@pdougall1]

Can ya'll talk about the best way to think about adding indexes? What is the problem when adding too many on a table for instance. Or when to reach for one when a query is slow. Confounding factors when there are other queries using the same column (not sure that's relevant). I'm sure there is a lot to consider that are just unknown unknowns for me.

[@NikolaySamokhvalov]

hey Patrick - have you listened to episode "068 Over-indexing"?

[@pdougall1]

@@NikolaySamokhvalov I have not, but definitely will. Also looks like there's one on under indexing as well! Might be exactly what I'm looking for, thanks!