Re: pg_dump & performance degradation

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pg_dump & performance degradation
Дата
Msg-id 200008011246.IAA14636@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: pg_dump & performance degradation  (Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>)
Список pgsql-hackers
> 
> Is this the sort of problem that nice() might solve, or not?

No.  Nice only handles CPU scheduling, not I/O.  In fact, most kernels
give I/O bound processed higher priority because they are using valuable
shared resources while doing the I/O, so the kernel wants it to finish
as quickly as possible.

> 
> Bruce Momjian wrote:
> > 
> > > >> 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.
> 


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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Lamar Owen
Дата:
Сообщение: Re: RPMs built for Mandrake
Следующее
От: Kovacs Zoltan Sandor
Дата:
Сообщение: pg_dump and pg_restore, speed