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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 3-days-long vacuum of 20GB table
Дата
Msg-id 3630.1208538238@sss.pgh.pa.us
обсуждение исходный текст
Ответ на 3-days-long vacuum of 20GB table  ("Jeffrey Baker" <jwbaker@gmail.com>)
Ответы Re: 3-days-long vacuum of 20GB table
Список pgsql-performance
"Jeffrey Baker" <jwbaker@gmail.com> writes:
> This autovacuum has been hammering my server with purely random i/o
> for half a week.  The table is only 20GB and the i/o subsystem is good
> for 250MB/s sequential and a solid 5kiops.  When should I expect it to
> end (if ever)?

What have you got maintenance_work_mem set to?  Which PG version
exactly?

            regards, tom lane

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

Предыдущее
От: "Jeffrey Baker"
Дата:
Сообщение: 3-days-long vacuum of 20GB table
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Strange behavior: pgbench and new Linux kernels