Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

Re: Finding bottleneck

Поиск
Список
Период
Сортировка
От Claus Guttesen
Тема Re: Finding bottleneck
Дата
Msg-id b41c75520507280452751f40f@mail.gmail.com
обсуждение исходный текст
Ответ на Finding bottleneck  (Kari Lavikka <tuner@bdb.fi>)
Список pgsql-performance
> effective_cache_size = 1000000  # typically 8KB each

I have this setting on postgresql 7.4.8 on FreeBSD with 4 GB RAM:

effective_cache_size = 27462

So eventhough your machine runs Debian and you have four times as much
RAM as mine your effective_cache_size is 36 times larger. You could
try lowering this setting.

regards
Claus

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