shared_buffers
The most fundamental memory configuration parameter in PostgreSQL, controlling the size of shared memory allocated to database processes for caching data pages, and directly affecting cache hit rates and I/O performance.
Timeline (last 90 days)
Postgres's shared_buffers is a memory pool used to cache data pages, and its default value is typically only 128MB.
In cloud environments where storage I/O is expensive, reasonably increasing shared_buffers and effective_cache_size can significantly reduce physical disk access and is one of the lowest-cost optimization measures.
The official Postgres documentation has long recommended setting shared_buffers to approximately 25% of system memory.
All Facts (3)
Postgres's shared_buffers is a memory pool used to cache data pages, and its default value is typically only 128MB.
50%UnverifiedIn cloud environments where storage I/O is expensive, reasonably increasing shared_buffers and effective_cache_size can significantly reduce physical disk access and is one of the lowest-cost optimization measures.
50%UnverifiedThe official Postgres documentation has long recommended setting shared_buffers to approximately 25% of system memory.
50%