Re: Increase default effective_cache_size?

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: Increase default effective_cache_size?
Дата
Msg-id 45178F1A.3030500@sigaev.ru
обсуждение исходный текст
Ответ на Increase default effective_cache_size?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Increase default effective_cache_size?  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
> 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Questions about guc units
Следующее
От: "Adrian Maier"
Дата:
Сообщение: Buildfarm failure at "initdb" - member Cassowary