Re: Vacuum never completed.... - Mailing list pgsql-general

From rolf@winmutt.com
Subject Re: Vacuum never completed....
Date
Msg-id d0cc251f6b769d1500e6d584d68ce41a@winmutt.com
Whole thread Raw
In response to Re: Vacuum never completed....  (Jeff Janes <jeff.janes@gmail.com>)
List 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 by date:

Previous
From: Vick Khera
Date:
Subject: Re: Initdb --data-checksums by default
Next
From: melvin6925
Date:
Subject: Fwd: Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created