pg_dump with low priority?
От | Bryan Field-Elliot |
---|---|
Тема | pg_dump with low priority? |
Дата | |
Msg-id | 1129984767.17898.3.camel@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: pg_dump with low priority?
Re: pg_dump with low priority? Re: pg_dump with low priority? |
Список | pgsql-general |
We have a huge database which must be backed up every day with pg_dump. The problem is, it takes around half an hour to produce the dump file, and all other processes on the same box are starved for cycles (presumably due to I/O) during the dump. It's not just an inconvenience, it's now evolved into a serious problem that needs to be addressed.
Is there any mechanism for running pg_dump with a lower priority? I don't mind if the backup takes two hours instead of half an hour, as long as other processes were getting their fair share of cycles.
Thank you for any advice,
Bryan
Is there any mechanism for running pg_dump with a lower priority? I don't mind if the backup takes two hours instead of half an hour, as long as other processes were getting their fair share of cycles.
Thank you for any advice,
Bryan
В списке pgsql-general по дате отправления: