Bernd Helmle wrote:
--On Samstag, Juli 11, 2009 13:40:44 +0300 Peter Eisentraut
<pete...@gmx.net> wrote:
OK, here is an updated patch. It has the setting as enum, completed
documentation, and libpq support. I'll add it to the commit fest in the
hope that someone else can look it over in detail.
I've started looking at this and did some profiling with large bytea
data again. For those interested, here are the numbers:
Dumping with bytea_output=hex (COPY to file):
real 20m38.699s
user 0m11.265s
sys 1m0.560s
Dumping with bytea_output=escape (COPY to file):
real 39m52.399s
user 0m22.085s
sys 1m50.131s
So the time needed dropped about 50%. The dump file dropped from
around 48 GB to 28 GB with the new format.
You just tested COPY, not pg_dump, right? Some pg_dump numbers would be
interesting, both for text and custom formats.
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers