SuSE help


PGSQL_SHARED_BUFFERS

The PGSQL_SHARED_BUFFERS variable defines a block of memory that PostgreSQL will use to hold requests that are awaiting attention from the kernel buffer and CPU.

Values

Integer, in MB

Default

240MB

Comments

The right value for this variable depends in part on the available RAM on the server where your site is running. For optimal performance, consider these settings:

8GB RAM 16GB RAM 32GB RAM 64GB RAM 128GB RAM
240MB 480MB 960MB 1.5GB 3.5GB
Related questions
What are the right PostgreSQL settings for my site?
More information
Full list of performance-related PosgreSQL parameters
PosgreSQL performance tips from the experts