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

Re: pg_dump & performance degradation

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Philip Warner <pjw(at)rhyme(dot)com(dot)au>, 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 01:48:41
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-hackers
> It would be a bad idea to nice down a backend anyway, if the intent is
> to speed up other backends.  The Unix scheduler has no idea about
> application-level locking, so you'll get priority-inversion problems:
> once the nice'd backend has acquired any sort of lock, other backends
> that may be waiting for that lock are at the mercy of the low priority
> setting.  In effect, your entire database setup may be running at the
> nice'd priority relative to anything else on the system.
> 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.  Does any other database
implement this?  I can accept it as a config.h flag, but it seems
publishing it as a pg_dump flag is just way too complicated for users.

  Bruce Momjian                        |
  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


pgsql-hackers by date

Next:From: Bruce MomjianDate: 2000-08-01 01:50:44
Subject: Re: Anyone care about type "filename" ?
Previous:From: Thomas SwanDate: 2000-08-01 01:44:43
Subject: Re: Announcement: I'm joining Great Bridge

pgsql-general by date

Next:From: K ParkerDate: 2000-08-01 02:10:35
Subject: Openlink ODBC drivers for Unix
Previous:From: Bruce MomjianDate: 2000-08-01 01:37:34
Subject: Re: pg_dump & performance degradation

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