Glossary — in plain language

Shared buffers


In plain English

Shared buffers is PostgreSQL own in-memory cache of data pages, shared by all connections. When a query needs a page, PostgreSQL looks here first before going to disk.

Why it matters

Sized too small, you read disk constantly; sized too large, you fight the OS cache and waste RAM. A common starting point is 25% of system memory.

Was this helpful?

← Browse the full glossary