Re: help with pg_dump timings

Поиск
Список
Период
Сортировка
От Arnau Rebassa Villalonga
Тема Re: help with pg_dump timings
Дата
Msg-id 434FC71B.40608@andromeiberica.com
обсуждение исходный текст
Ответ на help with pg_dump timings  (Chris Hoover <revoohc@gmail.com>)
Ответы Re: help with pg_dump timings  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-admin
Hi,

> Also, what -Z compression level equals the compression of gzip?  I've
> played with -Z9, but it seems to compress better than gzip (but takes a
> bit longer).

   I haven't done timing measurements but what I have noticed is that if
you use the custom format and after you try to compress the resultant
file, the size is not reduced that much, so it's not worth to spend time
compressing.

Cheers
--
Arnau



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

Предыдущее
От: "Nigel Bishop"
Дата:
Сообщение: DB cluster hanging
Следующее
От: faeiz
Дата:
Сообщение: PostgreSQL running in the background....