Re: BUG #13472: VACUUM ANALYZE hangs on certain tables - Mailing list pgsql-bugs

From Matthew Seaman
Subject Re: BUG #13472: VACUUM ANALYZE hangs on certain tables
Date
Msg-id 558D721E.2070908@adestra.com
Whole thread Raw
In response to BUG #13472: VACUUM ANALYZE hangs on certain tables  (matthew.seaman@adestra.com)
List pgsql-bugs
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)"=

>=20
> 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

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #13472: VACUUM ANALYZE hangs on certain tables
Next
From: kotlarski.krzysztof@gmail.com
Date:
Subject: BUG #13470: Logical replication 'invalid memory alloc'