Re: size of pg_dump files containing bytea values

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: size of pg_dump files containing bytea values
Дата
Msg-id 1820.1152759205@sss.pgh.pa.us
обсуждение исходный текст
Ответ на size of pg_dump files containing bytea values  ("Steve McWilliams" <smcwilliams@EmprisaNetworks.com>)
Ответы Re: size of pg_dump files containing bytea values  (Greg Stark <gsstark@mit.edu>)
Список pgsql-performance
"Steve McWilliams" <smcwilliams@EmprisaNetworks.com> writes:
> I notice that non-printables in bytea values are being spit out by pg_dump
> using escaped octet sequences even when the "-Fc" option is present
> specifying use of the custom binary output format rather than plain text
> format.  This bloats the size of bytea values in the dump file by a factor
> of 3+ typically.

No, because the subsequent compression step should buy back most of
that.

            regards, tom lane

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: hyper slow after upgrade to 8.1.4
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [Fwd: Delivery Status Notification (Failure)]