Re: BYTEA / DBD::Pg change in 9.0 beta - Mailing list pgsql-hackers

From Kenneth Marshall
Subject Re: BYTEA / DBD::Pg change in 9.0 beta
Date
Msg-id 20100518212926.GV3892@aart.is.rice.edu
Whole thread Raw
In response to Re: BYTEA / DBD::Pg change in 9.0 beta  (Alex Hunsaker <badalex@gmail.com>)
List pgsql-hackers
On Tue, May 18, 2010 at 03:26:17PM -0600, Alex Hunsaker wrote:
> On Tue, May 18, 2010 at 15:20, Jesper Krogh <jesper@krogh.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


pgsql-hackers by date:

Previous
From: Bernd Helmle
Date:
Subject: Re: BYTEA / DBD::Pg change in 9.0 beta
Next
From: Simon Riggs
Date:
Subject: Re: Keepalive for max_standby_delay