Postgresql: does effective_cache_size includes shared_buffers?

1 vote

3 answers

5118 views

postgresql postgresql-performance database-tuning

                          I am tuning a PG installation with 32GB of RAM.

The question is: which one of the following sentences is true?

1. effective_cache_size + shared_buffers ~= 30GB (PG knows that it has shared buffer plus the effective_cache_size)

2. effective_cache_size ~= 30GB (effective_cache_size includes shared_buffers)

Asked by collimarco (653 rep)

Nov 7, 2020, 10:57 AM
Last activity: Dec 25, 2024, 05:04 PM

Postgresql: does effective_cache_size includes shared_buffers?

Related Questions