From: Gavin Hamill <gdh@laterooms.com>
To: pgsql-performance@postgresql.org
Subject: Re: pg 8.1.3, AIX, huge box, painfully slow.
Date: Sat, 8 Apr 2006 00:39:19 +0100
Message-ID: <20060408003919.42b6f71a.gdh@laterooms.com> (raw)
In-Reply-To: <17515.1144450340@sss.pgh.pa.us>
References: <20060407185823.abe93017.gdh@laterooms.com>
<1144436060.32269.13.camel@state.g2switchworks.com>
<20060407205919.a091da26.gdh@laterooms.com>
<15772.1144440362@sss.pgh.pa.us>
<20060407223635.9c4a0b38.gdh@laterooms.com>
<17055.1144447009@sss.pgh.pa.us>
<20060407232759.45581362.gdh@laterooms.com>
<17515.1144450340@sss.pgh.pa.us>
On Fri, 07 Apr 2006 18:52:20 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Are you in a position to try your workload using PG CVS tip? There's
> a nontrivial possibility that we've already fixed this --- a couple
> months ago I did some work to reduce contention in the lock manager:
Well, there's a question. At the moment it's still live - but I'll need
to swap back to the Xeon machine since I can't afford to have a Saturday
with the db firing on three cylinders (out of eight :)
At that point you're welcome to twiddle, compile, throw anything you
want at it. If it helps us as much as the greater pg world, then that's
perfect.
> This is unfortunately not going to help you as far as getting that
> machine into production now (unless you're brave enough to run CVS tip
> as production, which I certainly am not).
.. if the problem can actually be boiled down to the locking/threading
issues, surely it should be straightforward to backport those changes
to 8.1.3 mainline?
> I'm afraid you're most
> likely going to have to ship that pSeries back at the end of the
> month, but while you've got it it'd be awfully nice if we could use
> it as a testbed ...
We have it for the next 2 weeks, and whilst I can't guarantee access for
all that time, you're welcome to hammer away at it over this weekend if
that's any help? Mail me privately and I'll sort out login details if
this is interesting.
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: <20060408003919.42b6f71a.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