On 06/26/15 16:21, Matthew Seaman wrote:
> Yes. There are in fact two table showing these symptoms, and they both
> get quite frequently updated. Periods of activity tend to wax and wane
> though, and both are pretty idle at the moment except for autovacuum
> processes "autovacuum: VACUUM public.page_tags (to prevent wraparound)"
>
> Even so, I'm still seeing the same symptoms: vacuum analyze hangs
My colleague has just informed me that they had been seeing vacuum hang
for around a week before the autovacuum 'to prevent wraparound' was
triggered.
Cheers,
Matthew