Re: pg_dump & performance degradation

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Don Baccus <dhogaza(at)pacifier(dot)com>, pgsql-hackers(at)postgresql(dot)org, brianb-pggeneral(at)edsamail(dot)com
Subject: Re: pg_dump & performance degradation
Date: 2000-08-01 03:41:59
Message-ID: 200008010341.XAA21148@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

> >> I think Philip's idea of adding some delays into pg_dump is a reasonable
> >> answer. I'm just recommending a KISS approach to implementing the
> >> delay, in the absence of evidence that a more complex mechanism will
> >> actually buy anything...
> >
> >I am worried about feature creep here.
>
> 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...
>
>
> >I can accept it as a config.h flag,
>
> You mean stick it in a bunch of ifdefs? What is the gain there?
>
>
> >but it seems
> >publishing it as a pg_dump flag is just way too complicated for users.
>
> I've missed something, obviously. What is the problem here?

I am more concerned with giving people a pg_dump option of questionable
value. I don't have problems adding it to the C code because it may be
of use to some people.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philip Warner 2000-08-01 04:00:28 Re: pg_dump & performance degradation
Previous Message Cheng Kai 2000-08-01 03:41:32 How to alter the size of a column

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2000-08-01 04:00:28 Re: pg_dump & performance degradation
Previous Message hstenger 2000-08-01 03:33:38 Re: Announcement: I'm joining Great Bridge