Re: pg_dump & performance degradation - Mailing list pgsql-hackers

From Don Baccus
Subject Re: pg_dump & performance degradation
Date
Msg-id 3.0.1.32.20000801060553.013e2ca0@mail.pacifier.com
Whole thread Raw
In response to Re: pg_dump & performance degradation  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
At 02:31 PM 8/1/00 +1000, Philip Warner wrote:

>>Have you tried pg_dump on a multi-processor machine, which most serious
>>database-backed websites run on these days?   Do you see the same
performance
>>degradation?  My site runs on a dual P450 with RAID 1 LVD disks, and cost
>>me exactly $2100 to build (would've been less if I'd laid off the extra
>>cooling fans!)
>
>The original request came from a person with a "4-CPU Xeon with 2GB of
>RAM", but the "solution" does not seem to work for them (I think), so it's
>probably a waste of time.

It seems really strange that pg_dump could suck the guts out of a
four-processor
machine.  What kind of device were they backing up to?   Disk?





- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.
 


pgsql-hackers by date:

Previous
From: Thomas Swan
Date:
Subject: Re: RPMs built for Mandrake
Next
From: Tom Lane
Date:
Subject: random() function produces wrong range