Re: BUG #13472: VACUUM ANALYZE hangs on certain tables

Поиск
Список
Период
Сортировка
От Matthew Seaman
Тема Re: BUG #13472: VACUUM ANALYZE hangs on certain tables
Дата
Msg-id 558D721E.2070908@adestra.com
обсуждение исходный текст
Ответ на BUG #13472: VACUUM ANALYZE hangs on certain tables  (matthew.seaman@adestra.com)
Список 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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: BUG #13472: VACUUM ANALYZE hangs on certain tables
Следующее
От: kotlarski.krzysztof@gmail.com
Дата:
Сообщение: BUG #13470: Logical replication 'invalid memory alloc'