From: Gavin Hamill <gdh@laterooms.com>
To: pgsql-performance@postgresql.org
Subject: Re: pg 8.1.3, AIX, huge box, painfully slow.
Date: Fri, 7 Apr 2006 22:19:34 +0100
Message-ID: <20060407221934.67cc2227.gdh@laterooms.com> (raw)
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>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gdh@laterooms.com
Subject: Re: pg 8.1.3, AIX, huge box, painfully slow.
In-Reply-To: <20060407221934.67cc2227.gdh@laterooms.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox