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