Bernd Helmle <mailings(at)oopsware(dot)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