Re: Pg_dump

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: Pg_dump
Дата
Msg-id 370989DB-26AD-451A-AF28-C4752E08FE77@elevated-dev.com
обсуждение исходный текст
Ответ на Re: Pg_dump  (Holger Jakobs <holger@jakobs.com>)
Ответы Re: Pg_dump  (jason cable <cablej2082@gmail.com>)
Список pgsql-admin
> Readers don't block writers, writers don't block readers in PostgreSQL.
>
> pg_dump is a reader.
>
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012

Additionally, I've done some stress testing and found that pg_dump puts surprisingly low load on our dbs. Of course,
likeeverything else, this dependent on your specifics--after all the dump will require reading all rows, so for
instanceif you're disk-bound, you could see a performance hit. But generally, if your db is running in a reasonably
"healthy"performance range and not already close to limits, pg_dump won't have a performance impact visible to users. 




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

Предыдущее
От: Holger Jakobs
Дата:
Сообщение: Re: Pg_dump
Следующее
От: jason cable
Дата:
Сообщение: Re: Pg_dump