Re: Increase default effective_cache_size?

> current default of 1000 pages (8Mb) seems really pretty silly for modern
> machines; we could certainly set it to 10 times that without problems,
> and maybe much more.  Thoughts?

May be, set by default effective_cache_size equal to number of shared buffers?
If pgsql is configured to  use quarter  or half of total memory for shared 
buffer, then effective_cache_size will have good approximation...



-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/