Re: Postgresql with max_connections=4096 - Mailing list pgsql-general

From Jeff Trout
Subject Re: Postgresql with max_connections=4096
Date
Msg-id 92EA2D56-2980-4A02-889B-42487BF34DC1@torgo.978.org
Whole thread Raw
In response to Re: Postgresql with max_connections=4096  (denis@edistar.com)
Responses Re: Postgresql with max_connections=4096
List pgsql-general
On Jul 27, 2005, at 4:22 AM, denis@edistar.com wrote:

> Already checked.
> We set a machine with only pg_pool installed as a fronted to the
> real db.
> If I disable persistent connections and I use pg_pool with 4096
> preforked clients,

no no no.
you don't want 4096 preforked clients.

What you want to do is leave it at the default 32 preforks and run a
copy of pgpool on each frontend.  Then point your app to connect ot
localhost (or the unix socket).  Be sure you change things to use a
"normal" connect not a persistant connect.  This should be fine for
you.   I used to run a site doing hundreds of connects & queries /
second across 4 frontends each of which ran a pg_pool connected to a
db box.

If you fine 32 clients isn't enough, then bump it up.  The idea is to
keep as few connections as possible.

--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/



pgsql-general by date:

Previous
From: Andrew Stewart
Date:
Subject: Daily digest?
Next
From: Audrey Bergeron-Morin
Date:
Subject: Re: duplicate messages?