| From: | rolf(at)winmutt(dot)com |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | Pgsql general <pgsql-general(at)postgresql(dot)org>, pgsql-general-owner(at)postgresql(dot)org |
| Subject: | Re: Vacuum never completed.... |
| Date: | 2016-04-20 20:48:36 |
| Message-ID: | d0cc251f6b769d1500e6d584d68ce41a@winmutt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
btree.
On 2016-04-19 06:53, Jeff Janes wrote:
> On Apr 19, 2016 6:37 AM, <rolf(at)winmutt(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | melvin6925 | 2016-04-20 20:50:28 | Fwd: Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created |
| Previous Message | Vick Khera | 2016-04-20 20:28:59 | Re: Initdb --data-checksums by default |