From: Chad Robinson <taskswap@yahoo.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Problem with asynchronous connect in 8.0.1
Date: Tue, 8 Feb 2005 11:30:31 -0800 (PST)
Message-ID: <20050208193032.29435.qmail@web11610.mail.yahoo.com> (raw)
In-Reply-To: <9068.1107888077@sss.pgh.pa.us>
--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Chad Robinson <taskswap@yahoo.com> writes:
> > I'm not sure I can use Postgres though. I'm having a terrible time
> > getting large numbers of clients connected. I need to have upwards
> > of 8000 clients attached at any one time.
>
> Unless you actually need 8000 simultaneous transactions in process,
> connection pooling is the way to go. I haven't played much with pgpool
> though --- it may have a few issues to shake out ...
It seems so. I have to have this many connections, because for security and
privacy reasons the processes involved are isolated. There are about
1000-1200 per box, 4-8 boxes, depending on how I load-balance things. Unless
you know some way to REDUCE memory usage per Postgres client connection,
we'll see how things go with pgpool.
Thanks for your help.
-Chad
__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: taskswap@yahoo.com, tgl@sss.pgh.pa.us
Subject: Re: Problem with asynchronous connect in 8.0.1
In-Reply-To: <20050208193032.29435.qmail@web11610.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox