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