Skip site navigation (1) Skip section navigation (2)

Re: pg_dump & performance degradation

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 04:12:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-hackers
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!)

If not, the target audience has shrunk even further.   Any way you cut it,
backups want to be scheduled for low-volume hours and even internationally
popular sites don't have steady volume for each hour of the 24 hour day.

(after all, some hours of the day that correspond to the normal "traffic
jam" hours fall mostly in areas like the south pacific where few people
live, even if each and every one is an avid user the load they put on
popular sites is bound to be low compared to, say, the eastern seaboard
or Europe)

If your site's so popular that it has to be perky 24 hours a day for a
rabid base of worldwide fans, then you can either:

1. afford to invest in hardware (if not, you're not asking enough of your
2. afford to invest in other improvements in your website.

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.

But, then again, I'm the kinda guy that looks for simple solutions to simple

- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at

In response to


pgsql-hackers by date

Next:From: Don BaccusDate: 2000-08-01 04:15:10
Subject: Re: pg_dump & performance degradation
Previous:From: Chris BitmeadDate: 2000-08-01 04:10:37
Subject: Re: Classes and Inheritance

pgsql-general by date

Next:From: Michael Talbot-WilsonDate: 2000-08-01 04:14:43
Subject: Re: How to alter the size of a column
Previous:From: Philip WarnerDate: 2000-08-01 04:00:28
Subject: Re: pg_dump & performance degradation

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group