Inside PostgreSQL's 8KB Page

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

If you read previous post about buffers , you already know PostgreSQL might not necessarily care about your rows. You might be inserting a user profile, or retrieving payment details, but all that Postgres works with are blocks of data. 8KB blocks, to be precise. You want to retrieve one tiny row? PostgreSQL hauls an entire 8,192-byte page off the disk just to give it to you. You update a single…

Read on boringsql.com ↗