Re: To keep indexes in memory, is large enough effective_cache_size enough? - Mailing list pgsql-performance

From Sergei Kornilov
Subject Re: To keep indexes in memory, is large enough effective_cache_size enough?
Date
Msg-id 5456011537348252@sas1-fed4e4c8a570.qloud-c.yandex.net
Whole thread Raw
In response to To keep indexes in memory, is large enough effective_cache_sizeenough?  ("Sam R." <samruohola@yahoo.com>)
Responses Re: To keep indexes in memory, is large enough effective_cache_sizeenough?  ("Sam R." <samruohola@yahoo.com>)
List pgsql-performance
Hi

effective_cache_size is not cache. It is just approx value for query planner: how many data can be found in RAM (both
inshared_buffers and OS page cache)
 

> Q: Size of shared_buffers does not matter regarding keeping index in memory?
shared_buffers is cache for both tables and indexes pages. All data in tables and indexes are split to chunks 8 kb each
-pages (usually 8kb, it can be redefined during source compilation).
 
Shared buffers cache is fully automatic, active used pages keeps in memory, lower used pages may be evicted. You can
notpin any table or index to shared buffers.
 

regards, Sergei


pgsql-performance by date:

Previous
From: Sergei Kornilov
Date:
Subject: Re: How to see/calculate size of index in memory?
Next
From: "Sam R."
Date:
Subject: Re: To keep indexes in memory, is large enough effective_cache_sizeenough?