Re: PQunescapeBytea code - Mailing list pgsql-hackers

From Adam Kavan
Subject Re: PQunescapeBytea code
Date
Msg-id 5.2.1.1.0.20031030174139.00ab01b0@pop.central.cox.net
Whole thread Raw
In response to Re: PQunescapeBytea code  ("Jeroen T. Vermeulen" <jtv@xs4all.nl>)
Responses Re: PQunescapeBytea code
List pgsql-hackers
Actually I was looking at that code today and it does not ignore something 
if it is escaped by a backslash on not on the list.  It eats the backslash 
and then continues the loop so next time that character will be parsed 
normally.  However PQunescapeBytea is _very_ slow.  I am storing fairly 
large (several hundered K) byte strings into Bytea's and it can take 30 
seconds or more to convert them back into binary data.  I wrote a new 
version of PQunescapeBytea that uses pointers instead of arrays to store 
the string in, this increases the speed about 30 fold on my strings and 
still has the same behavior.  I wasn't sure if this would be something I 
should submit as a patch or not, is anyone interested in this?

If they are I'll try to figure out how to submit a patch.

--- Adam Kavan
--- akavan@cox.net



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: 7.4RC1 planned for Monday
Next
From: Larry Rosenman
Date:
Subject: Re: 7.4RC1 planned for Monday