X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 94B46D1B34A for ; Wed, 4 Aug 2004 10:10:42 -0300 (ADT) 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 32590-03 for ; Wed, 4 Aug 2004 13:10:46 +0000 (GMT) Received: from mx.mall.cz (mx.mall.cz [62.168.45.106]) by svr1.postgresql.org (Postfix) with ESMTP id 86B67D1B1DF for ; Wed, 4 Aug 2004 10:10:35 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mx.mall.cz (Postfix) with ESMTP id 2A9A04810E; Wed, 4 Aug 2004 15:10:43 +0200 (CEST) Received: from mx.mall.cz ([127.0.0.1]) by localhost (posta [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28620-01; Wed, 4 Aug 2004 15:10:34 +0200 (CEST) Message-ID: <4110E05F.9030404@taborsky.cz> Date: Wed, 04 Aug 2004 15:10:55 +0200 From: Michal Taborsky User-Agent: Mozilla Thunderbird 0.7.1 (Windows/20040626) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Paul Serby Cc: pgsql-performance@postgresql.org Subject: Re: The black art of postgresql.conf tweaking References: <4110DA83.7020505@clockltd.com> In-Reply-To: <4110DA83.7020505@clockltd.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/47 X-Sequence-Number: 7683 Paul Serby wrote: > Apache on the Web server can take up to 300 connections and PHP is using > pg_pconnect > max_connections = 300 > But Apache is still maxing out the non-super user connection limit. Don't forget also that some connections are reserved for superusers (usually 2), so if you want 300 users, you need to set max_connections to 300 + superuser_reserved_connections. -- Michal Taborsky http://www.taborsky.cz