PostgreSQL Checkpoint Demystified

PostgreSQL checkpoint process

PostgreSQL Checkpoint: Database blocks are temporarily stored in Database shared buffers. As blocks are read, they are stored in DB shared buffers so that if any user accesses them later, they are available in memory and need not be read from the disk. When we update any row, the buffer in DB shared buffers corresponding … Read more