Re: Re: Fast Inserts and Hardware Questions - Mailing list pgsql-general

From Gordon A. Runkle
Subject Re: Re: Fast Inserts and Hardware Questions
Date
Msg-id 98rduc$kd5$1@news.tht.net
Whole thread Raw
In response to Re: Fast Inserts and Hardware Questions  (Alex Howansky <alex@wankwood.com>)
Responses Re: Re: Fast Inserts and Hardware Questions  (Alex Howansky <alex@wankwood.com>)
List pgsql-general
In article
<Pine.LNX.4.30.0103141957490.14894-100000@net-srv-0001.bvrd.com>, "Alex
Howansky" <alex@wankwood.com> wrote:

[Interesting stats]

> Wow, does WAL make so much of a difference as to make my
> two-generations-old, built-from-spare-parts scrap box faster than my
> latest and greatest production server? Yikes!

What RAID level are you running?  RAID-5 isn't always very
fast on writes.  That and WAL might be what's up.

Have you tried 7.1b5 on the big box?

Gordon.
--
It doesn't get any easier, you just go faster.
   -- Greg LeMond

pgsql-general by date:

Previous
From: Mont Erickson
Date:
Subject: Postgres SQL Query (Generating Date Groups)
Next
From: yves@mail2.vlaanderen.net
Date:
Subject: Postgresql database size problem