Re: Inconsistent performance

Поиск
Список
Период
Сортировка
От Matt Clark
Тема Re: Inconsistent performance
Дата
Msg-id LFEIJBEOKGPDHCEMDGNFMEHGCCAA.matt@ymogen.net
обсуждение исходный текст
Ответ на Re: Inconsistent performance  (Joseph Bove <jbove@vetstar.com>)
Список pgsql-performance
Дерево обсуждения 
...
> #effective_cache_size = 1000    # typically 8KB each

That's horribly wrong.  It's telling PG that your OS is only likely to cache
8MB of the DB in RAM.  If you've got 1GB of memory it should be between
64000 and 96000

В списке pgsql-performance по дате отправления: