Re: pg 8.1.3, AIX, huge box, painfully slow.

From: Richard Huxton <dev(at)archonet(dot)com>
To: Gavin Hamill <gdh(at)laterooms(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: pg 8.1.3, AIX, huge box, painfully slow.
Date: 2006-04-10 09:06:41
Message-ID: 443A2021.5070105@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Gavin Hamill wrote:
> On Fri, 07 Apr 2006 15:24:18 -0500
> Scott Marlowe <smarlowe(at)g2switchworks(dot)com> wrote:
>
>>> See reply to Tom Lane :)
>> I didn't see one go by yet... Could be sitting in the queue.
>
> If it's not arrived by now - EXPLAIN ANALYZE doesn't tell me
> anything :)
>
>> Let us know if changing the fsync setting helps. Hopefully that's all
>> the problem is.
>
> fsync's already off - yes a bit scary, but our I/O is only about
> 500KB/sec writing.. the whole db fits in RAM / kernel disk cache, and
> I'd rather have performance than security at this exact moment..

>>> Multi-Opteron was the other thing we considered but decided to give
>>> 'Big Iron' UNIX a whirl...
>> It still might be a good choice, if it's a simple misconfiguration
>> issue.
>>
>> But man, those new multiple core opterons can make some impressive
>> machines for very little money.
>
> So I see - we could buy two quad-opterons for the cost of renting this
> pSeries for a month....

I don't know about the pSeries, but I had a client the other week with
the same usage pattern. They made the switch from a quad Xeon to dual
(+dual-core) Opteron and were extremely impressed.

I can probably put you in touch with their sysadmin - contact me
off-list if you'd like that.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2006-04-10 09:23:48 Re: OT: Data structure design question: How do they count
Previous Message Marcin Mańk 2006-04-10 09:02:40 Re: Restore performance?