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?
Список 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 по дате отправления: