X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A20FB8B9FAD for ; Tue, 8 Feb 2005 19:30:40 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48009-07 for ; Tue, 8 Feb 2005 19:30:33 +0000 (GMT) Received: from web11610.mail.yahoo.com (web11610.mail.yahoo.com [216.136.129.39]) by svr1.postgresql.org (Postfix) with SMTP id 137638B9FAF for ; Tue, 8 Feb 2005 19:30:33 +0000 (GMT) Received: (qmail 29444 invoked by uid 60001); 8 Feb 2005 19:30:32 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=kQm9s2kZhVy1RIgGly4/2qGre7/FHmN6BCPyPPGaHxtjj9UpAjjDD0mDEPapyraM4f/8+c9fGfsWLC8fmZwCC/TGnTv3oFeKSBRYbipdIcEdgqYAE2U97LtBDycxQ7MXat7ujyC2kPpBUS79tGOKk71cF7NXiwY4b0e8SQvdlpY= ; Message-ID: <20050208193032.29435.qmail@web11610.mail.yahoo.com> Received: from [206.53.65.228] by web11610.mail.yahoo.com via HTTP; Tue, 08 Feb 2005 11:30:31 PST Date: Tue, 8 Feb 2005 11:30:31 -0800 (PST) From: Chad Robinson Subject: Re: Problem with asynchronous connect in 8.0.1 To: Tom Lane Cc: pgsql-interfaces@postgresql.org In-Reply-To: <9068.1107888077@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.258 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200502/19 X-Sequence-Number: 5264 --- Tom Lane wrote: > Chad Robinson 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