medium10 pts · first answer countspostgresqlperformance

Sizing shared_buffers

A dedicated PostgreSQL server has 64 GB of RAM. Which shared_buffers setting is a sensible starting point?

A.128 MB, the default is always bestB.About 16 GB (roughly 25 percent of RAM), leaving the rest for the OS cache and work memoryC.60 GB, so almost all data is in PostgreSQL memoryD.64 GB, equal to total RAM

← Bad plan right after a bulk load Session state behind pgBouncer →