Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: size of pg_dump files containing bytea values
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Steve McWilliams" <smcwilliams(at)EmprisaNetworks(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: size of pg_dump files containing bytea values
- Date: Wed, 12 Jul 2006 22:53:25 -0400
- Message-id: <1820.1152759205@sss.pgh.pa.us> <text/plain>
"Steve McWilliams" <smcwilliams(at)EmprisaNetworks(dot)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
- Follow-Ups:
- Re: size of pg_dump files containing bytea values
- From: Greg Stark
- Re: size of pg_dump files containing bytea values
- References:
- size of pg_dump files containing bytea values
- From: Steve McWilliams
- size of pg_dump files containing bytea values
- Prev by Date: Re: hyper slow after upgrade to 8.1.4
- Next by Date: Re: [Fwd: Delivery Status Notification (Failure)]
- Previous by thread: size of pg_dump files containing bytea values
- Next by thread: Re: size of pg_dump files containing bytea values
- Indexes: