Re: size of pg_dump files containing bytea values - Mailing list pgsql-performance

From Tom Lane
Subject Re: size of pg_dump files containing bytea values
Date
Msg-id 1820.1152759205@sss.pgh.pa.us
Whole thread Raw
In response to size of pg_dump files containing bytea values  ("Steve McWilliams" <smcwilliams@EmprisaNetworks.com>)
Responses Re: size of pg_dump files containing bytea values
List 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 by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: hyper slow after upgrade to 8.1.4
Next
From: Tom Lane
Date:
Subject: Re: [Fwd: Delivery Status Notification (Failure)]