Re: 3-days-long vacuum of 20GB table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 3-days-long vacuum of 20GB table
Дата
Msg-id 6256.1208545748@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 3-days-long vacuum of 20GB table  ("Jeffrey Baker" <jwbaker@gmail.com>)
Список pgsql-performance
"Jeffrey Baker" <jwbaker@gmail.com> writes:
> I increased it to 1GB, restarted the vacuum, and system performance
> seems the same.  The root of the problem, that an entire CPU is in the
> iowait state and the storage device is doing random i/o, is unchanged:

Yeah, but you just reduced the number of index scans that will be needed
by a factor of 1GB/16MB.  Hang in there ...

            regards, tom lane

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: 3-days-long vacuum of 20GB table
Следующее
От: Jesper Krogh
Дата:
Сообщение: Re: Message queue table..