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