Re: BYTEA / DBD::Pg change in 9.0 beta

On Tue, May 18, 2010 at 03:26:17PM -0600, Alex Hunsaker wrote:
> On Tue, May 18, 2010 at 15:20, Jesper Krogh <jesper(at)krogh(dot)cc> wrote:
> > On 2010-05-18 23:12, Alex Hunsaker wrote:
> >>
> >> set bytea_output 'escape';
> >
> > That was it. Knowing what the problem was I had no problem finding it in the
> > release notes.
> >
> > May I ask whats the reason is for "breaking" the compatibillity?
>
> There were a couple IIRC, the big ones being speed and size. Id look
> at the archives for more.
>
> I imagine at some point DBD::Pg will handle this transparently. I
> also imagine Greg would happily accept patches :-)
>

Yes, the new format is much faster, more space efficient, and uses
less CPU to do the encoding. The older format caused the COPY for
bytea to be CPU limited in many more situations.

Regards,
Ken