X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 484B49FCF67 for ; Mon, 28 Aug 2006 11:28:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 62090-03 for ; Mon, 28 Aug 2006 11:28:43 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.199]) by postgresql.org (Postfix) with ESMTP id EC9939FCF60 for ; Mon, 28 Aug 2006 11:28:43 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id 14so905088nzn for ; Mon, 28 Aug 2006 07:28:42 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ji9c5N8feDsG8VS7djFKA0XgPoRIqAbeZywkA+3k1eclNE61FGvZel0aSK9IQBQpb3hn934tRe39L5K0EjLm2mzSFBkc2K9U+k4A4Q9gxOeD5qyBvo4LydFk9cTwc2JlOZUCAL3USZhrZmYTBxP7P9wKX8Wz5NCg9P0nT6lAb0I= Received: by 10.65.81.19 with SMTP id i19mr6910824qbl; Mon, 28 Aug 2006 07:28:42 -0700 (PDT) Received: by 10.64.27.7 with HTTP; Mon, 28 Aug 2006 07:28:42 -0700 (PDT) Message-ID: Date: Mon, 28 Aug 2006 14:28:42 +0000 From: "Christopher Browne" To: "Ravindran G - TLS, Chennai." , pgsql-performance@postgresql.org, "Isac Newton A - TLS, Chennai." Subject: Re: Postgre SQL 7.1 cygwin performance issue. In-Reply-To: <20060828141959.GD27526@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <012301731C23DE4DBFE035647C68F1CC03BE0092@sindhu.ctd.hcltech.com> <20060828141959.GD27526@alvh.no-ip.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.183 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/435 X-Sequence-Number: 20620 On 8/28/06, Alvaro Herrera wrote: > > Please advise us on how to resolve this ?. > > There's no solution short of upgrading. That's a little too negative. There is at least one alternative, possibly two... 1. Migrate the database to a Unix platform that does not suffer from the Cygwin 64 connection restriction. (If running Linux, it may be necessary to look for an old release, as there were changes to GLIBC at around the same time as 7.2 that don't play perfectly well with 7.1...) 2. It is *possible* that pg_pool could be usable as a proxy that limits the number of connections actually used. I'm not sure how well it'll play with 7.1, mind you... --=20 http://www3.sympatico.ca/cbbrowne/linux.html Oddly enough, this is completely standard behaviour for shells. This is a roundabout way of saying `don't use combined chains of `&&'s and `||'s unless you think G=F6del's theorem is for sissies'.