Bernd Helmle <maili...@oopsware.de> writes: > From time to time we had complains about slow dump of large tables with > bytea columns, people often complaining about a) size and b) duration of > the dump.
> That latter occurred recently to me, a customer would like to dump large > tables (approx. 12G in size) with pg_dump, but he was annoyed about the > performance. Using COPY BINARY reduced the time (unsurprisingly) to a > fraction (from 12 minutes to 3 minutes). Seems like the right response might be some micro-optimization effort on byteaout. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers