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.
Integer, in MB
240MB
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 |