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

From Tom Lane
Subject Re: Huge spikes in number of connections doing "PARSE"
Date
Msg-id 26590.1300201132@sss.pgh.pa.us
Whole thread Raw
In response to Re: Huge spikes in number of connections doing "PARSE"  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: Huge spikes in number of connections doing "PARSE"  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-general
hubert depesz lubaczewski <depesz@depesz.com> writes:
> while I understand it, and will pass this information to client, one
> thing bugs me - one the problem happens only sometimes, with relatively
> low count of backends?
> we saw database running normally with 1200 connections, yet sometimes,
> it has 500 connections, and then something happens and they all end up
> locking in this parse mode.

Well, if they're all busy, you're not going to get this cache reset
problem.  It's idle backends that have fallen behind that create the
problem.

            regards, tom lane

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Huge spikes in number of connections doing "PARSE"
Next
From: tv@fuzzy.cz
Date:
Subject: Re: PostgreSQL for Holdem Manager could not be installed.