Search Postgresql Archives

Re: pgpool

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> So - would it then be worth doing pgpool?

You could limit the number of connections to PostgreSQL.
--
Tatsuo Ishii

> On Sat, 15 Jan 2005 11:12:04 +0900 (JST), Tatsuo Ishii
> <t-ishii@xxxxxxxxx> wrote:
> > > John Cunningham wrote:
> > > > concerned that if I drop the number of connections to less than the
> > > > number of databases I have, that pgpool would open the limit of
> > > > connections, hold them open and not allow any connections to the
> > > > remaining databases.  Is this a concern?  If I set up pgpool will I
> > > > have to have the same number of connections as I have databases?
> > >
> > > That depends on how you configure pgpool.  pgpool is not aware of the
> > > connection limit count in the PostgreSQL server, so it will happily
> > > open connections until there are no more slots available.
> > >
> > > pgpool will require max_pool * num_init_children connection slots.
> > >
> > > max_pool should be the number of database/user combinations you use
> > > (300 in your case, assuming only one database user account),
> > 
> > Not really. If a user connects to pgpool and all onnection slots are
> > already full, then pgpool will release the oldest connection slot and
> > reuse it for the new connection. So even if there are 300
> > database/user combinations, it's ok to set max_pool as low as, for
> > example, 4. Of course this will have unwanted side effect in that
> > connection caches are not very well kept, though.
> > --
> > Tatsuo Ishii
> > 
> > >  and
> > > num_init_children should be on the order of how many concurrent
> > > connections you expect to each combination ("several" in your case).
> > > So you should have at least 300 * several PostgreSQL connection slots,
> > > which is probably more than the 1000 or so that is the default.
> > >
> > > --
> > > Peter Eisentraut
> > > http://developer.postgresql.org/~petere/
> > > 
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 4: Don't 'kill -9' the postmaster
> > >
> >
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
> 

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux