Re: Huge spikes in number of connections doing "PARSE"

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/