Re: pg_dump & performance degradation

Поиск
Список
Период
Сортировка
От Don Baccus
Тема Re: pg_dump & performance degradation
Дата
Msg-id 3.0.1.32.20000801060553.013e2ca0@mail.pacifier.com
обсуждение исходный текст
Ответ на Re: pg_dump & performance degradation  (Philip Warner <pjw@rhyme.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Swan
Дата:
Сообщение: Re: RPMs built for Mandrake
Следующее
От: Tom Lane
Дата:
Сообщение: random() function produces wrong range