Skip site navigation (1) Skip section navigation (2)

Re: Connection Pooling....an interesting question!! (was..Connection Pooling...(Repost)...please do help...)

From: "Adam Lang" <aalang(at)rutgersinsurance(dot)com>
To:
Cc: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: Connection Pooling....an interesting question!! (was..Connection Pooling...(Repost)...please do help...)
Date: 2000-12-16 17:36:06
Message-ID: 009701c06786$abb1aac0$330a0a0a@6014cwpza006 (view raw or flat)
Thread:
Lists: pgsql-interfaces
I'm not saying anything about postgres not being able to handle that many
connections.  I'm just saying it shouldn't if it doesn't have to.

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
----- Original Message -----
From: "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su>
To: "Adam Lang" <aalang(at)rutgersinsurance(dot)com>
Cc: <pgsql-interfaces(at)postgresql(dot)org>
Sent: Saturday, December 16, 2000 12:28 PM
Subject: Re: [INTERFACES] Connection Pooling....an interesting question!!
(was..Connection Pooling...(Repost)...please do help...)


> On Sat, 16 Dec 2000, Adam Lang wrote:
>
> > Date: Sat, 16 Dec 2000 12:07:16 -0500
> > From: Adam Lang <aalang(at)rutgersinsurance(dot)com>
> > To: pgsql-interfaces(at)postgresql(dot)org
> > Subject: Re: [INTERFACES] Connection Pooling....an interesting
question!! (was..Connection Pooling...(Repost)...please do help...)
> >
> > As (I believe) Joel mentioned, you should use a distributed
architecture.
> > Clients shouldn't directly access your db server.  I believe it is
> > "acceptable" if you are only looking at a small app that 10 people are
going
> > to use, but 200 hundred clients is a lot.
> >
> > You should have postgres on one tier, your clients on one, and devise a
> > middle tier that acts as a relay between your clients and postgres.
That
> > way the 200 connections are not handled by postgres.  Postgres will only
> > need to handle the 10 or so you pool with the middle tier.
>
> Brrr, we have 128 persistent connections without any problem.
> Just use -N option. I dont' remember maximum number of backends compiled
> on default, but you could always change this number.
> But you're right whe you speaking about 3-tire model. We're experimenting
> with Corba and preliminary results are promising
>
>
> Regards,
> Oleg
>
> _____________________________________________________________
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83


In response to

Responses

pgsql-interfaces by date

Next:From: Sanjay AroraDate: 2000-12-16 19:52:33
Subject: Re: Connection Pooling....an interesting question!! (was..Connection Pooling...(Repost)...please do help...)
Previous:From: Oleg BartunovDate: 2000-12-16 17:28:17
Subject: Re: Connection Pooling....an interesting question!! (was..Connection Pooling...(Repost)...please do help...)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group