Re: Configuration settings for 32GB RAM server

Поиск
Список
Период
Сортировка
От Joshua Marsh
Тема Re: Configuration settings for 32GB RAM server
Дата
Msg-id 38242de90612041057j63672f7qafa6c6059e9901dc@mail.gmail.com
обсуждение исходный текст
Ответ на Configuration settings for 32GB RAM server  ("Mark Lonsdale" <mark.lonsdale@wysdm.com>)
Ответы Re: Configuration settings for 32GB RAM server  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-performance


On 12/4/06, Mark Lonsdale <mark.lonsdale@wysdm.com> wrote:

Maintenance_work_mem = 1048576 – Figured Id allocate 1GB for this.


Do you know how often and when you will be creating indexes or clustering?  We set ours to 2GB because of the performance gains.  We've also thought about testing it at 4GB.  We can do this because we know during the middle of the night our server load drops to nearly zero.  If you know you have windows like that, then I would definitely suggest increasing your maintenance_work_mem.  It's halved the time for io intesive tasks like cluster.

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

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: Configuration settings for 32GB RAM server
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: How to move pg_xlog to another drive on Windows????