Re: Vacuum performance question

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: Vacuum performance question
Дата
Msg-id 1060884297.14006.27.camel@jester
обсуждение исходный текст
Ответ на Vacuum performance question  ("Jeremy M. Guthrie" <jeremy.guthrie@berbee.com>)
Список pgsql-performance
> I've allocated 196MB of RAM to vacuums.

I would be willing to bet that you have kicked the system into swap
because of this.  Hence the large decrease in speed.

Try sliding back to 32MB for vacuum. A ton more ram doesn't really help
it all that much.

Вложения

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

Предыдущее
От: "Jeremy M. Guthrie"
Дата:
Сообщение: Vacuum performance question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] EXTERNAL storage and substring on long strings