On Mon, Mar 14, 2011 at 10:21:27PM +0100, Martijn van Oosterhout wrote: > The common factor seems to be lots of index locks. Do you have very > many indexes? $ select count(*) from pg_class where relkind = 'i'; count ------- 450 (1 row) $ select count(*) from pg_class where relkind = 'r'; count ------- 201 (1 row) not sure if that's many. -- The best thing about modern society is how easy it is to avoid contact with it. http://depesz.com/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general