Re: Help how to tune-up my Database

Поиск
Список
Период
Сортировка
От Bricklen
Тема Re: Help how to tune-up my Database
Дата
Msg-id h4Pmc.5347$uN4.1032@clgrps12
обсуждение исходный текст
Ответ на Re: Help how to tune-up my Database  ("scott.marlowe" <scott.marlowe@ihs.com>)
Ответы Re: Help how to tune-up my Database  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-performance
scott.marlowe wrote:
> sort_mem might do with a small bump, especially if you're only handling a
> few connections at a time.  Be careful, it's per sort, and measured in
> megs, so it's easy for folks to set it too high and make their machine
> start flushing too much kernel cache, which will slow down the other
> backends that have to go to disk for data.
<snip>
http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html
(under "Memory"), it says that sort_mem is set in KB. Is this document
wrong (or outdated)?

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

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: Why queries takes too much time to execute?
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: Why queries takes too much time to execute?