Episode Details

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: 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: 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: 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: 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: Migration from other DBMSs
• PostgreSQL transition/migration guide https://github.com/postgresql-transition-guide/guide  

• Question 6: Latest failover best practices
• Patroni https://github.com/zalando/patroni

~~~

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

Listen Now