Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 697CE2E002C for ; Mon, 7 Apr 2008 17:53:20 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 98963-07 for ; Mon, 7 Apr 2008 17:53:10 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from mu-out-0910.google.com (mu-out-0910.google.com [209.85.134.190]) by developer.postgresql.org (Postfix) with ESMTP id 7ECB82E0038 for ; Mon, 7 Apr 2008 17:53:13 -0300 (ADT) Received: by mu-out-0910.google.com with SMTP id i10so2342701mue.5 for ; Mon, 07 Apr 2008 13:53:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=Z3W5ZRSjISUTFDl3qA83ZRuCXmeAIaxsknnPnPwS6DM=; b=TJyjj7mku5FJiA8EU0rFBBDNNM53ExxHoRNCC2DoI4j34CbEyoTPjexlNXDxfBjKKcg7iw2gottI9rmJdtwaiTokDJC1BPjNYU35Xy0KADZk+bmfFCEqiL8eSUljZTtVkLfwXox5R7FjpaN8IkEgoynZokHPZNzxogJe5oTu4dY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=m354D0LmdLfbAUBoe6DLGH25b5WTGPXiwN7PxzkfW3XiAm/Ugx2mVPpqTbVL7OTZ+yFNCmlqNzD47j52OiwDXdaWn4V7ezldol0qjbbDkMwIflOQirRf+WGDH640czGnSgH45oUk3A9zQC/WKu2ac02JKgbpenUozDKOX87Uoaw= Received: by 10.78.68.18 with SMTP id q18mr12437652hua.72.1207601588257; Mon, 07 Apr 2008 13:53:08 -0700 (PDT) Received: by 10.78.187.20 with HTTP; Mon, 7 Apr 2008 13:53:08 -0700 (PDT) Message-ID: Date: Mon, 7 Apr 2008 22:53:08 +0200 From: "Mario Ferloni" To: "Benjamin Krajmalnik" Subject: Re: Windows max concurrent connections Cc: "Scott Marlowe" , pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/57 X-Sequence-Number: 28821 Hi, (reposting... I replied directly to sender instead than to the mailing list...) On Thu, Apr 3, 2008 at 6:47 PM, Scott Marlowe wrote: > On Thu, Apr 3, 2008 at 10:11 AM, Mario Ferloni wrote: > > > > I am a bit concerned about the max concurrent connection problem > > documented in the windows faq > > (http://www.postgresql.org/docs/faqs.FAQ_windows.html#4.4), that is > > due to user32.dll limitations. Now, my question is: what is the status > > of this problem as of 8.3.1 version? > > Have you looked into connection pooling? > mmm... I have done a little searching about it (consider I am a bit new to the pg world :) ): * pgpool-II is not supported under windows. anyone has experience on it? * pgbouncer? but the user.txt file... * memcache seems to me to be not a viable solution (requires rewriting any app to make use of it...) or... is there anybody out there that faced the same problem? how do you managed to solve it? can you point me to some documentation about connection pooling? thanks in advance! best regards, -- MF