Re: Extreme high load averages

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: Extreme high load averages
Дата
Msg-id 3F083CCA.31144.7468C@localhost
обсуждение исходный текст
Ответ на Extreme high load averages  (Martin Foster <martin@ethereal-realms.org>)
Ответы Re: Extreme high load averages  (Martin Foster <martin@ethereal-realms.org>)
Список pgsql-performance
On 5 Jul 2003 at 22:54, Martin Foster wrote:
> What I would like to know is.   Why?   The kernel has been compiled to
> handle the number of concurrent connections, the server may not be the
> best, but it should be able to handle the requests: PIII 1Ghz, 1GB
> SDRAM, 2 IDE 20GB drives.
>
> I have changed settings to take advantage of the memory.  So the
> following settings are of interest:
>     shared_buffers = 16384
>     wal_buffers = 256
>     sort_mem = 16384
>     vacuum_mem = 32768

As somebody else has already pointed out, your sort_mem is bit too high
than required. Try lowering it.

Secondly did you tune effective_cache_size?

HTH
Bye
 Shridhar

--
Power, n.:    The only narcotic regulated by the SEC instead of the FDA.


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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Extreme high load averages
Следующее
От: Martin Foster
Дата:
Сообщение: Re: Extreme high load averages