Request a Demo
Home   >   mailing lists

Re: Huge spikes in number of connections doing "PARSE" - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: Huge spikes in number of connections doing "PARSE"
Date
Msg-id 20110314215030.GA14895@depesz.com
Whole thread Raw
In response to Re: Huge spikes in number of connections doing "PARSE"  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Re: Autocommit off - commits/rollbacks
Next
From: Rajesh Kumar Mallah
Date:
Subject: base backup and tar problems with disappearing files.