On 15 June 2012 19:22, Benedict Holland <benedict.m.holland@xxxxxxxxx> 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 (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
