From: | "Steve McWilliams" <smcwilliams(at)EmprisaNetworks(dot)com> |
---|---|
To: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | size of pg_dump files containing bytea values |
Date: | 2006-07-12 18:36:27 |
Message-ID: | 3985.10.1.1.126.1152729387.squirrel@portal.emprisanetworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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. When you have alot of large bytea values in your db this
can add up very quickly.
Shouldn't the custom format be smart and just write the raw bytes to the
output file rather than trying to make them ascii readable?
Thanks.
Steve McWilliams
Software Engineer
Emprisa Networks
703-691-0433x21
smcwilliams(at)emprisanetworks(dot)com
The information contained in this communication is intended only for the
use of the recipient named above, and may be legally privileged,
confidential and exempt from disclosure under applicable law. If the
reader of this communication is not the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication, or any of its contents, is strictly prohibited. If you have
received this communication in error, please resend this communication to
the sender and delete the original communication and any copy of it from
your computer system. Thank you.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2006-07-12 19:25:39 | Re: Commit slower on faster PC |
Previous Message | Joshua D. Drake | 2006-07-12 17:46:05 | Re: Commit slower on faster PC |