From owner-freebsd-performance@FreeBSD.ORG  Tue Aug 23 01:27:15 2005
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
X-Original-To: freebsd-performance@freebsd.org
Delivered-To: freebsd-performance@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id C583516A41F
	for <freebsd-performance@freebsd.org>;
	Tue, 23 Aug 2005 01:27:15 +0000 (GMT)
	(envelope-from decibel@decibel.org)
Received: from flake.decibel.org (flake.decibel.org [67.100.216.10])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 5D22243D45
	for <freebsd-performance@freebsd.org>;
	Tue, 23 Aug 2005 01:27:15 +0000 (GMT)
	(envelope-from decibel@decibel.org)
Received: by flake.decibel.org (Postfix, from userid 1001)
	id DC9DE152AD; Mon, 22 Aug 2005 20:27:13 -0500 (CDT)
Date: Mon, 22 Aug 2005 20:27:13 -0500
From: "Jim C. Nasby" <decibel@decibel.org>
To: Michael VInce <mv@roq.com>
Message-ID: <20050823012713.GN17203@decibel.org>
References: <b41c755205080410013348d0f@mail.gmail.com>
	<42F6B4CD.5030703@roq.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <42F6B4CD.5030703@roq.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
Cc: freebsd-performance@freebsd.org, Claus Guttesen <kometen@gmail.com>
Subject: Re: changing max_connections in postgresql on FreeBSD 5.4
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 23 Aug 2005 01:27:15 -0000

On Mon, Aug 08, 2005 at 11:26:37AM +1000, Michael VInce wrote:
> Also note that I have a MySQL server with a similar table setup and it 
> performs a lot better.

If you provide example queries that are performing worse than in MySQL
along with the output of EXPLAIN ANALYZE on them to the PostgreSQL
performance tuning list I'm sure you'd get some help. Include details
about your machine configuration and postgresql.conf variables you've
changed too.

Also, make sure you're actually running MySQL in such a way that it's
ACID compliant; it's very easy to configure it so that your data isn't
safe at all, which would be an apples-oranges comparison to PostgreSQL.
-- 
Jim C. Nasby, Database Architect                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?"