Understanding buffer life cycle in PostgreSQL
What happens when you execute a transaction in PostgreSQL? The block will be fetched to shared buffers, executed there and upon commit, the dirty buffer will leave to disk again,…
postgresql acid properties