Anniversary mailbag | Postgres.FM 053 | #PostgreSQL #Postgres podcast

Nikolay and Michael celebrate the podcast's 1 year anniversary by going through several questions and suggestions received over the year.

Here are the questions and some links to things we mentioned:

* Question 1 [04:32]: Effect of wal_log_hints=on after bulk Deletes: Why next select runs slow and generated tons of WAL? https://twitter.com/dmx551/status/1598253188926570496
* wal_log_hints https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-WAL-LOG-HINTS
* Exploring how SELECT Queries can produce disk writes https://blog.okmeter.io/postgresql-exploring-how-select-queries-can-produce-disk-writes-f36c8bee6b6f

* Question 2 [09:32]: How to get started reading PostgreSQL source code. Maybe a PostgreSQL style C reference guide to consult with for non C programmers https://twitter.com/andatki/status/1578088843940593678
* So, you want to be a developer? https://wiki.postgresql.org/wiki/So,_you_want_to_be_a_developer%3F
* GitHub search https://github.com/search?q=repo%3Apostgres%2Fpostgres+wal_log_hints&type=code
* The Internals of PostgreSQL (by Hironobu SUZUKI) https://www.interdb.jp/pg/
* PostgreSQL 14 Internals (by Egor Rogov) https://postgrespro.com/community/books/internals

* Question 3 [13:18]: Isolation Levels Primer/Strategies — their uses in different scenarios, battle tested strategies and insights, performance tradeoffs, edge cases to consider at scale (with replication and sharding, etc.) I remember reading some interesting stuff on the jepsen analysis https://jepsen.io/analyses/postgresql-12.3 about Postgres's Serializable Isolation Level behaving more like Snapshot Isolation. Has this type of behavior or another one similar to this affected you or your clients in any significant way?
* Transaction Isolation https://www.postgresql.org/docs/current/transaction-iso.html
* What developers find surprising about Postgres transactions https://blog.lawrencejones.dev/isolation-levels/

* Question 4 [20:48]: Data encryption in Postgres
* Cybertec Transparent Data Encryption https://www.cybertec-postgresql.com/en/products/postgresql-transparent-data-encryption/
* EDB Transparent Data Encryption https://www.enterprisedb.com/docs/tde/latest/

* Question 5 [27:09]: Migration from other DBMSs
* PostgreSQL transition/migration guide https://github.com/postgresql-transition-guide/guide

* Question 6 [35:10]: Latest failover best practices
Patroni https://github.com/zalando/patroni