Re: Inefficient bytea escaping?

Tom Lane wrote:
> I wrote:
>
>>I'm off for a little visit with oprofile...
>
>
> It seems the answer is that fwrite() does have pretty significant
> per-call overhead, at least on Fedora Core 4. The patch I did yesterday
> still ended up making an fwrite() call every few characters when dealing
> with bytea text output, because it'd effectively do two fwrite()s per
> occurrence of '\' in the data being output. I've committed a further
> hack that buffers a whole data row before calling fwrite(). Even though
> this presumably is adding one extra level of data copying, it seems to
> make things noticeably faster:

(semi-OT) This recoding seems like a perfect preparation for a third
COPY format, compressed.

>
> Let me know what this does on your Debian machine ...

Takes a while, need a different kernel booted because the current isn't
oprofile ready.

Regards,
Andreas