X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id EAA8C11F60AF
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri,  7 Apr 2006 18:19:41 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 44622-09
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri,  7 Apr 2006 18:19:37 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from fon.nation-net.com (213-2-2-26.uk.vianw.net [213.2.2.26])
	by postgresql.org (Postfix) with ESMTP id 6DBA211F6026
	for <pgsql-performance@postgresql.org>;
	Fri,  7 Apr 2006 18:19:39 -0300 (ADT)
Received: from fon.nation-net.com (localhost [127.0.0.1])
	by fon.nation-net.com (Postfix) with ESMTP id E94B9137594
	for <pgsql-performance@postgresql.org>;
	Fri,  7 Apr 2006 22:19:37 +0100 (BST)
Received: from eddie.acentral.co.uk
	(80-192-144-33.cable.ubr04.pres.blueyonder.co.uk [80.192.144.33])
	by fon.nation-net.com (Postfix) with ESMTP id CF91C136CD9
	for <pgsql-performance@postgresql.org>;
	Fri,  7 Apr 2006 22:19:37 +0100 (BST)
Received: from eddie.acentral.co.uk (eddie.acentral.co.uk [127.0.0.1])
	by eddie.acentral.co.uk (Postfix) with ESMTP id 3E48275FE5
	for <pgsql-performance@postgresql.org>;
	Fri,  7 Apr 2006 22:19:40 +0100 (BST)
Received: from localhost.localdomain (unknown [10.0.0.29])
	by eddie.acentral.co.uk (Postfix) with SMTP id 2C1EA75D0A
	for <pgsql-performance@postgresql.org>;
	Fri,  7 Apr 2006 22:19:40 +0100 (BST)
Date: Fri, 7 Apr 2006 22:19:34 +0100
From: Gavin Hamill <gdh@laterooms.com>
To: pgsql-performance@postgresql.org
Subject: Re: pg 8.1.3, AIX, huge box, painfully slow.
Message-Id: <20060407221934.67cc2227.gdh@laterooms.com>
In-Reply-To: <20060407161602.7ed5f672.darcy@druid.net>
References: <20060407185823.abe93017.gdh@laterooms.com>
	<1144436060.32269.13.camel@state.g2switchworks.com>
	<20060407205919.a091da26.gdh@laterooms.com>
	<20060407161602.7ed5f672.darcy@druid.net>
X-Mailer: Sylpheed version 2.1.1 (GTK+ 2.8.6; i486-pc-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: ClamAV using ClamSMTP
X-AV-Checked: ClamAV using ClamSMTP
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.09 required=5 tests=[AWL=0.090]
X-Spam-Score: 0.09
X-Spam-Level: 
X-Archive-Number: 200604/156
X-Sequence-Number: 18240

On Fri, 7 Apr 2006 16:16:02 -0400
"D'Arcy J.M. Cain" <darcy@druid.net> wrote:

> We also had problems with a high end AIX system and we got no help
> from IBM.  They expected you to put Oracle on and if you used
> anything else you were on your own.  

Urk, I thought IBM were supposedly Linux sycophants thesedays...

> We had exactly the same issue.
> We expected to get an order of magnitude improvement and instead the
> app bogged down.

That's kind of encouraging, I suppose - that it might not be something
mind-bogglingly stupid I'm doing.

> It also got worse over time.  We had to reboot every
> night to get anything out of it.  Needless to say, they got their
> system back.

<nod>
 
> That's Seneca.

Oops - meant to check the spelling before I sent that =)
 
> We found that our money was better spent on multiple servers running
> NetBSD with a home grown multi-master replication system.  Need more
> power?  Just add more servers.

Aye, I originally suggested multiple servers, but was talked round to
one giant db so that our devels didn't have to rewrite code to deal
with read/write + read-only db handles...

Cheers,
Gavin.