On 15 June 2012 19:22, Benedict Holland <[email protected]> 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 -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
