Re: Vacuum never completed....

Поиск
Список
Период
Сортировка
От rolf@winmutt.com
Тема Re: Vacuum never completed....
Дата
Msg-id d0cc251f6b769d1500e6d584d68ce41a@winmutt.com
обсуждение исходный текст
Ответ на Re: Vacuum never completed....  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-general
btree.

On 2016-04-19 06:53, Jeff Janes wrote:
> On Apr 19, 2016 6:37 AM, <rolf@winmutt.com> wrote:
>>
>> We had a server approach wraparound yesterday on a 9.3 box. I
> restarted in single user mode and only one table was above
> autovacuum_freeze_max_age. The dataset was ~750G. We left vacuum
> running for 21hrs and it still did not complete. What was interesting
> is that disk IO graph kept cycling, lots of reads for ~45min, then a
> few writes for another 45min.
>
> What kind of indexes were on the table?
>
> Cheers,
>
> Jeff



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

Предыдущее
От: Vick Khera
Дата:
Сообщение: Re: Initdb --data-checksums by default
Следующее
От: melvin6925
Дата:
Сообщение: Fwd: Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created