Re: Re: Fast Inserts and Hardware Questions
От | Alex Howansky |
---|---|
Тема | Re: Re: Fast Inserts and Hardware Questions |
Дата | |
Msg-id | Pine.LNX.4.30.0103161545280.14467-100000@net-srv-0001.bvrd.com обсуждение исходный текст |
Ответ на | Re: Re: Fast Inserts and Hardware Questions ("Gordon A. Runkle" <gar@no-spam-integrated-dynamics.com>) |
Ответы |
Re: Re: Re: Fast Inserts and Hardware Questions
Re: Re: Re: Fast Inserts and Hardware Questions |
Список | 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/
В списке pgsql-general по дате отправления: