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

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
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-04-30 18:55:09
Message-ID: m2k4eby3g2.fsf@2ndQuadrant.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> we have n (~ 40 i think) web servers. each webserver has it's own
> pgbouncer (in session pooling).

In some cases I have found useful to have those webserver's pgbouncer
connect to another pgbouncer on the database host. But if your problem
is tied to real active connection, I don't see what it would solve.
Still, if you're searching ideas…

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2011-04-30 19:17:30 Re: Huge spikes in number of connections doing "PARSE"
Previous Message Mark 2011-04-30 18:37:18 Re: GIN index not used