Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Autovacuum stuck for hours, blocking queries - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: [GENERAL] Autovacuum stuck for hours, blocking queries
Date
Msg-id 20170215223314.xcdwpgecvt7tukrj@alvherre.pgsql
Whole thread Raw
In response to Re: [GENERAL] Autovacuum stuck for hours, blocking queries  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
Scott Marlowe wrote:

> Then a ddl gets in line. It has to wait on the vacuum, and the vacuum,
> set to run super slow. And everybody waits. On vacuum.

Note that this is normally not seen, because autovacuum cancels itself
when somebody is blocked behind it -- until the table reaches the
freeze_max_age limit, and then autovacuum is a for-wraparound one that
is no longer terminated, and then everybody has to wait on it.

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: [GENERAL] Autovacuum stuck for hours, blocking queries
Next
From: Shawn Thomas
Date:
Subject: Re: [GENERAL] Can't restart Postgres