Reads causing writes | Postgres FM | Episode 132 (opens in new tab)

Nikolay and Michael discuss a couple of surprising ways read queries (selects) can cause writes (shared buffers dirtied) in Postgres. Here are some links to things they mentioned:Reads causing writes in Postgres (post by Alex Jesipow) Hint Bits (wiki) pg_stat_kcache pg_wait_sampling BUFFERS by default (episode 4!) Page layout (docs) From Reddit (user merlinm), PD_ALL_VISIBLE may be a third case Coroot ~~~What did you like or not like? What should we discuss next time? Let us know via a YouTub...