Postgres Pro
Downloads
Home   >   mailing lists

Re: Increase default effective_cache_size? - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: Increase default effective_cache_size?
Date
Msg-id 45178F1A.3030500@sigaev.ru
Whole thread Raw
In response to Increase default effective_cache_size?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Increase default effective_cache_size?  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Tree view 
> 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/

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Questions about guc units
Next
From: "Adrian Maier"
Date:
Subject: Buildfarm failure at "initdb" - member Cassowary