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/