On Wed, Oct 10, 2012 at 5:12 PM, Strahinja Kustudić
<strahinjak@nordeus.com> wrote:
> @Claudio So you are basically saying that if I have set effective_cache_size
> to 10GB and I have 10 concurrent processes which are using 10 different
> indices which are for example 2GB, it would be better to set the
> effective_cache size to 1GB? Since if I leave it at 10GB each running
> process query planner will think the whole index is in cache and that won't
> be true? Did I get that right?
Yep. You might get away with setting 2GB, if you're willing to bet
there won't be 100% concurrency. But the safest setting would be 1G.