-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: 16 February 2017 22:40
To: Tim Bellis
Cc: Adrian Klaver ; pgsql-general@postgresql.org;
Alvaro Herrera ; Scott Marlowe
Subject: Re: [GENERAL] Autovacuum stuck for hours, blocking queries
Tim Bellis writes
From: Jeff Janes [mailto:jeff.ja...@gmail.com]
Sent: 17 February 2017 02:59
To: Tim Bellis
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Autovacuum stuck for hours, blocking queries
On Wed, Feb 15, 2017 at 9:30 AM, Tim Bellis
mailto:tim.bel...@metaswitch.com>> wrote:
I
.@erven.at]
Sent: 17 February 2017 11:47
To: pgsql-general@postgresql.org
Cc: Tim Bellis
Subject: Re: [GENERAL] Autovacuum stuck for hours, blocking queries
Hi Tim,
Am 2017-02-15 um 18:30 schrieb Tim Bellis:
> I have a postgres 9.3.4 database table which (intermittently but
> reliably
Thank you all - that's really useful :-)
The other query that gets blocked behind the vacuum is the below (truncated).
This query is generated by jdbc in this method:
org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getIndexInfo(AbstractJdbc2DatabaseMetaData.java:4023)
Even though this is a re
I have a postgres 9.3.4 database table which (intermittently but reliably) gets
into a state where queries get blocked indefinitely (at least for many hours)
behind an automatic vacuum. I was under the impression that vacuum should never
take any blocking locks for any significant period of time
