| From: | Alex Howansky <alex(at)wankwood(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Re: Fast Inserts and Hardware Questions |
| Date: | 2001-03-16 21:53:22 |
| Message-ID: | Pine.LNX.4.30.0103161545280.14467-100000@net-srv-0001.bvrd.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> [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.
Yes, it is RAID-5 on the big box. Unfortunately, I don't have any spare RAID
equipped boxes sitting around, so I can't experiment with the different RAID
levels. Still, you'd think that even a "slow" RAID-5 configuration would be
faster than a $98 IDE drive...
> Have you tried 7.1b5 on the big box?
Not yet, I'm waiting for a quiet weekend. I'll post my stats when (if...) I get
around to doing that.
--
Alex Howansky
Wankwood Associates
http://www.wankwood.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philip Crotwell | 2001-03-16 22:00:51 | pgdump, large objects and 7.0->7.1 |
| Previous Message | Ron Chmara | 2001-03-16 21:28:22 | Re: ssl connections with psql |