From: | Philip Warner <pjw(at)rhyme(dot)com(dot)au> |
---|---|
To: | Don Baccus <dhogaza(at)pacifier(dot)com>, 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 04:31:28 |
Message-ID: | 3.0.5.32.20000801143128.02e34bc0@mail.rhyme.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
At 21:12 31/07/00 -0700, Don Baccus wrote:
>At 01:06 PM 8/1/00 +1000, Philip Warner wrote:
>
>>I agree; it's definitely a non-critical feature. But then, it is only 80
>>lines of code in one place (including 28 non-code lines). I am not totally
>>happy with the results it produces, so I have no objection to removing it
>>all. I just need some more general feedback...
>
>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.
>Doing such unheard of things to a utility (again, is there any Unix or NT
>or VMS etc utility that has such a user option?) makes me think you're
>finger-pointing at the wrong part of your service.
I agree; I think in an earlier post I did say that I was trying to 'fix' an
OS issue in the application, which is really not a good thing to do...but
there *is* a problem. Just no solution, apparently.
>But, then again, I'm the kinda guy that looks for simple solutions to simple
>problems...
It was simple when I started. Honest...
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.C.N. 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Warner | 2000-08-01 04:34:48 | Re: pg_dump & performance degradation |
Previous Message | Bruce Momjian | 2000-08-01 04:26:06 | Re: pg_dump & performance degradation |
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Warner | 2000-08-01 04:34:48 | Re: pg_dump & performance degradation |
Previous Message | Bruce Momjian | 2000-08-01 04:26:06 | Re: pg_dump & performance degradation |