From: | rolf(at)winmutt(dot)com |
---|---|
To: | Pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Vacuum never completed.... |
Date: | 2016-04-19 13:35:59 |
Message-ID: | c36900d3df3d7980636ba1ea070a5749@winmutt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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. I failed to VACUUM VERBOSE so there was little other
data to go on other than IO graph. We ended dropping the table and
lowering autovacuum_freeze_max_age for clean up. We've had similar sized
dataset complete vacuum in a few hours, but I've never seen this cycling
IO before: https://imagebin.ca/v/2eIdB2bjFBxq
Is this normal? It gave me very little faith that VACUUM would ever
complete.
From | Date | Subject | |
---|---|---|---|
Next Message | Sachin Kotwal | 2016-04-19 13:48:24 | Re: error while installing auto_explain contrib module |
Previous Message | Adrian Klaver | 2016-04-19 13:32:14 | Re: error while installing auto_explain contrib module |