Re: Update blocking a select count(*)?

From: Peter Geoghegan <peter(at)2ndquadrant(dot)com>
To: Benedict Holland <benedict(dot)m(dot)holland(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Update blocking a select count(*)?
Date: 2012-06-15 18:32:37
Message-ID: CAEYLb_WqEecnjr5o0DoNh15kNF_FXGkErVKw7fCGM5xxNLmrvQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 15 June 2012 19:22, Benedict Holland <benedict(dot)m(dot)holland(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2012-06-15 18:41:02 Re: Update blocking a select count(*)?
Previous Message Benedict Holland 2012-06-15 18:22:03 Update blocking a select count(*)?