From:
Don Baccus <dhogaza(at)pacifier(dot)com>
To:
Philip Warner <pjw(at)rhyme(dot)com(dot)au>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
pgsql-hackers(at)postgresql(dot)org, brianb-pggeneral(at)edsamail(dot)com
Subject:
Re: pg_dump & performance degradation
Date:
2000-08-01 13:05:53
Message-ID:
3.0.1.32.20000801060553.013e2ca0@mail.pacifier.com (view raw or flat )
Thread:
2000-07-28 14:41:52 from Philip Warner <pjw(at)rhyme(dot)com(dot)au>
2000-07-28 16:22:37 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2000-07-28 16:52:57 from Philip Warner <pjw(at)rhyme(dot)com(dot)au>
2000-07-28 17:36:35 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2000-07-29 04:14:11 from Philip Warner <pjw(at)rhyme(dot)com(dot)au>
2000-07-29 04:57:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2000-07-29 05:58:17 from Philip Warner <pjw(at)rhyme(dot)com(dot)au>
2000-07-29 12:28:02 from Don Baccus <dhogaza(at)pacifier(dot)com>
2000-07-29 13:27:45 from Philip Warner <pjw(at)rhyme(dot)com(dot)au>
2000-07-29 15:34:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2000-07-31 03:20:15 from Philip Warner <pjw(at)rhyme(dot)com(dot)au>
2000-08-01 01:48:41 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2000-08-01 03:06:51 from Philip Warner <pjw(at)rhyme(dot)com(dot)au>
2000-08-01 03:41:59 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2000-08-01 04:00:28 from Philip Warner <pjw(at)rhyme(dot)com(dot)au>
2000-08-01 04:15:10 from Don Baccus <dhogaza(at)pacifier(dot)com>
2000-08-01 04:26:06 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2000-08-01 04:34:48 from Philip Warner <pjw(at)rhyme(dot)com(dot)au>
2000-08-01 06:49:44 from Thomas Swan <tswan(at)olemiss(dot)edu>
2000-08-01 04:38:43 from Chris Bitmead <chrisb(at)nimrod(dot)itg(dot)telstra(dot)com(dot)au>
2000-08-01 04:56:51 from Philip Warner <pjw(at)rhyme(dot)com(dot)au>
2000-08-01 12:46:38 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2000-08-01 04:12:57 from Don Baccus <dhogaza(at)pacifier(dot)com>
2000-08-01 04:31:28 from Philip Warner <pjw(at)rhyme(dot)com(dot)au>
2000-08-01 13:05:53 from Don Baccus <dhogaza(at)pacifier(dot)com>
2000-08-01 13:37:04 from Philip Warner <pjw(at)rhyme(dot)com(dot)au>
2000-08-01 05:36:58 from brianb-pggeneral(at)edsamail(dot)com
2000-08-01 06:54:49 from Philip Warner <pjw(at)rhyme(dot)com(dot)au>
2000-08-01 07:48:32 from Thomas Swan <tswan(at)olemiss(dot)edu>
2000-08-01 01:37:34 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Lists:
pgsql-general 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(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net .
In response to
Responses
pgsql-hackers by date
Next :From: Philip WarnerDate: 2000-08-01 13:37:04Subject : Re: pg_dump & performance degradationPrevious :From : Philip WarnerDate : 2000-08-01 13:02:26Subject : pg_dump & ownership (again)
pgsql-general by date
Next :From: abeDate: 2000-08-01 13:19:22Subject : Someone Needed!!Previous :From : Bruce MomjianDate : 2000-08-01 12:46:38Subject : Re: pg_dump & performance degradation
