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
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? |