Postgres Pro
Downloads
Home   >   mailing lists

Re: Update blocking a select count(*)? - Mailing list pgsql-performance

From Peter Geoghegan
Subject Re: Update blocking a select count(*)?
Date
Msg-id CAEYLb_WqEecnjr5o0DoNh15kNF_FXGkErVKw7fCGM5xxNLmrvQ@mail.gmail.com
Whole thread Raw
In response to Update blocking a select count(*)?  (Benedict Holland <benedict.m.holland@gmail.com>)
Responses Re: Update blocking a select count(*)?
List pgsql-performance
Tree view 
On 15 June 2012 19:22, Benedict Holland <benedict.m.holland@gmail.com> wrote:
> Do I seem to have this right and is there anything I can do?

There are a couple of maintenance operations that could block a
select. Do you see any AccessExclusive locks within pg_locks? That's
the only type of lock that will block a select statement's AccessShare
lock.

--
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services

pgsql-performance by date:

Previous
From: Benedict Holland
Date:
Subject: Update blocking a select count(*)?
Next
From: "Kevin Grittner"
Date:
Subject: Re: Update blocking a select count(*)?