effective_cache_size: Better set it right This is an off-site link.  Please review our Terms of Service for additional information.

(Hans-Juergen Schoenig) PostgreSQL knows a parameter called effective_cache_size. To many this is one of the most mysterious settings in the entire PostgreSQL config. Maybe this is the core reason why many people just completely ignore this setting – in many cases this is not the best idea of all. effective_cache_size can have a serious impact on execution plans and change things dramatically.

Read this article...

comments powered by Disqus