Re: size of pg_dump files containing bytea values

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: size of pg_dump files containing bytea values
Дата
Msg-id 87k66hii11.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: size of pg_dump files containing bytea values  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: size of pg_dump files containing bytea values  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: size of pg_dump files containing bytea values  (Florian Weimer <fweimer@bfk.de>)
Список pgsql-performance
Tom Lane <tgl@sss.pgh.pa.us> writes:

> "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.

Didn't byteas used to get printed as hex? Even in psql they're now being
printed in the escaped octet sequence. When did this change?

--
greg

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: hyper slow after upgrade to 8.1.4
Следующее
От: Tom Lane
Дата:
Сообщение: Re: hyper slow after upgrade to 8.1.4