Re: pg_dump & performance degradation

Поиск
Список
Период
Сортировка
От Thomas Swan
Тема Re: pg_dump & performance degradation
Дата
Msg-id 4.3.2.7.2.20000731234504.02b1ed48@sunset.backbone.olemiss.edu
обсуждение исходный текст
Ответ на Re: pg_dump & performance degradation  (Don Baccus <dhogaza@pacifier.com>)
Список pgsql-hackers
My $.02 ...
 :)

Anyway, the command line option makes the most sense.    An arbitrary or relative sleep timer specified as an option is an ideal way to go about it.  I really liked the
pg_dump -T {pick a number, any number} idea.   maybe a -d  for delay or something...

Note:  A command line option is not too difficult for someone to use.  (I saw someone mention this.)   If you're using a GUI and rely on it... get someone to add a check box for the option.   Otherwise if your actually using a command-line utility, you've got the hardest part licked...  (It's a nice FAQ item, why is my db so slow when doing a backup? ... how can I fix this? ...)

This seems a little rhetorical in some respects... I would want a backup or dump of the DB to hit as quickly as possible... (scheduled for a low load time).  But if, hypothetically, the load is constant, then a more relaxed backup might be in order...

All in all, hard coding in the delay, would aggravate me and quite a few others; can't you hear it, "Why the *#!##@$ is this taking so long?"

-
- Thomas Swan                                   
- Graduate Student  - Computer Science
- The University of Mississippi
-
- "People can be categorized into two fundamental
- groups, those that divide people into two groups
- and those that don't."

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

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: RPMs built for Mandrake
Следующее
От: Lamar Owen
Дата:
Сообщение: Re: RPMs built for Mandrake