Return-Path: <pgsql-general-owner+M81222@postgresql.org>
Received: from hosting.commandprompt.com ([207.173.200.128])
	by mta8.adelphia.net
	(InterMail vM.6.01.04.01 201-2131-118-101-20041129) with ESMTP id
	<20050727181314.ZKCE29961.mta8.adelphia.net@hosting.commandprompt.com>;
	Wed, 27 Jul 2005 14:13:14 -0400
Received: from postgresql.org (svr1.postgresql.org [200.46.204.71])
	by hosting.commandprompt.com (8.13.4/8.13.4) with ESMTP id
	j6RIAON7010980; Wed, 27 Jul 2005 11:10:24 -0700
X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 96E9E52C17
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Wed, 27 Jul 2005 14:53:31 -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 21001-05
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Wed, 27 Jul 2005 17:53:29 +0000 (GMT)
Received: from flake.decibel.org (flake.decibel.org [67.100.216.10])
	by svr1.postgresql.org (Postfix) with ESMTP id 0215552BF4
	for <pgsql-general@postgresql.org>;
	Wed, 27 Jul 2005 14:53:29 -0300 (ADT)
Received: by flake.decibel.org (Postfix, from userid 1001)
	id 479F01523C; Wed, 27 Jul 2005 12:53:29 -0500 (CDT)
Date: Wed, 27 Jul 2005 12:53:29 -0500
From: "Jim C. Nasby" <decibel@decibel.org>
To: denis@edistar.com
Cc: Jeff Trout <threshar@torgo.978.org>, Richard Huxton <dev@archonet.com>,
	"pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] Postgresql with max_connections=4096
Message-ID: <20050727175329.GX26758@decibel.org>
References: <42E73347.7010500@edistar.com> <42E73D54.10001@archonet.com>
	<42E74458.70704@edistar.com>
	<92EA2D56-2980-4A02-889B-42487BF34DC1@torgo.978.org>
	<42E79E60.2060104@edistar.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <42E79E60.2060104@edistar.com>
X-Operating-System: FreeBSD 4.11-RELEASE-p10 i386
X-Distributed: Join the Effort!  http://www.distributed.net
User-Agent: Mutt/1.5.9i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Mailing-List: pgsql-general
List-Archive: <http://archives.postgresql.org/pgsql-general>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-general.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@postgresql.org>
List-Post: <mailto:pgsql-general@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-general>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

On Wed, Jul 27, 2005 at 04:46:56PM +0200, denis@edistar.com wrote:
> I'm now testing with pg_pool installed on each apache frontend with 260 
> pg_pool preforked clients in each machine.
> 
> The database seems to work better. At least when it goes to swap it 
> doesn't stop working...

Wait, are you saying your database server is swapping? You'll never get
any kind of performance if that's the case.
-- 
Jim C. Nasby, Database Consultant               decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend


