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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: depesz(at)depesz(dot)com
Cc: Noah Misch <noah(at)leadboat(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Huge spikes in number of connections doing "PARSE"
Date: 2011-03-15 14:58:52
Message-ID: 26590.1300201132@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hubert depesz lubaczewski <depesz(at)depesz(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tv 2011-03-15 15:04:17 Re: PostgreSQL for Holdem Manager could not be installed.
Previous Message hubert depesz lubaczewski 2011-03-15 14:40:31 Re: Huge spikes in number of connections doing "PARSE"