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, but how does that happen? The answer is here. PostgreSQL is an ORDBMS software, Let’s ignore O for time being (we will have a separate … Read more