Re: pg_dump & performance degradation

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   |/