Re: Performance of pg_dump on PGSQL 8.0

Поиск
Список
Период
Сортировка
От John Vincent
Тема Re: Performance of pg_dump on PGSQL 8.0
Дата
Msg-id c841561b0606141416w3c5cee35mc05d219700027755@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance of pg_dump on PGSQL 8.0  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-performance
time gzip -6 claDW_PGSQL.test.bak

real    3m4.360s
user    1m22.090s
sys     0m6.050s

Which is still less time than it would take to do a compressed pg_dump.

On 6/14/06, Scott Marlowe <smarlowe@g2switchworks.com> wrote:
How long does gzip take to compress this backup?

On Wed, 2006-06-14 at 15:59, John Vincent wrote:
> Okay I did another test dumping using the uncompressed backup on the
> system unloaded and the time dropped down to 8m for the backup.
> There's still the size issue to contend with but as I said, I've got a
> fair bit of space left on the SAN to work with.

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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Performance of pg_dump on PGSQL 8.0
Следующее
От: "John Vincent"
Дата:
Сообщение: Re: Performance of pg_dump on PGSQL 8.0