Glossary — in plain language

Page (data block)


In plain English

PostgreSQL reads and writes data in fixed-size chunks called pages (8 kB by default). Every table and index is a sequence of pages, and the cache (shared_buffers) holds copies of hot pages in memory.

Why it matters

Counting pages is how costs are measured. EXPLAIN buffers, bloat, and I/O all come back to “how many pages did we touch”. A “dirty” page is one changed in memory but not yet written to disk.

Was this helpful?

← Browse the full glossary