{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"Anniversary mailbag","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/22ae451a\"></iframe>","width":"100%","height":180,"duration":1884,"description":"Nikolay and Michael celebrate the podcast's 1 year anniversary by going through several questions and suggestions received over the year.\n \nHere are the questions and some links to things we mentioned: \nQuestion 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 \nwal_log_hints https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-WAL-LOG-HINTS \nExploring how SELECT Queries can produce disk writes https://blog.okmeter.io/postgresql-exploring-how-select-queries-can-produce-disk-writes-f36c8bee6b6f\n\nQuestion 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 \nSo, you want to be a developer? https://wiki.postgresql.org/wiki/So,_you_want_to_be_a_developer%3F\nGitHub search https://github.com/search?q=repo%3Apostgres%2Fpostgres+wal_log_hints&type=code \nThe Internals of PostgreSQL (by Hironobu SUZUKI) https://www.interdb.jp/pg/ \nPostgreSQL 14 Internals (by Egor Rogov) https://postgrespro.com/community/books/internals \n\nQuestion 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?\nTransaction Isolation https://www.postgresql.org/docs/current/transaction-iso.html\nWhat developers find surprising about Postgres transactions https://blog.lawrencejones.dev/isolation-levels/  \n\nQuestion 4: Data encryption in Postgres\nCybertec Transparent Data Encryption...","thumbnail_url":"https://img.transistorcdn.com/NFbJlGhGV5mzIU1kM0iZ823A69pjZUNX40LszVO5LKI/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}