Re: bytea, index and like operator again and detailed - Mailing list pgsql-hackers

From Alvar Freude
Subject Re: bytea, index and like operator again and detailed
Date
Msg-id 4028430000.1070676025@gnarzelwicht.delirium-arts.de
Whole thread Raw
In response to Re: bytea, index and like operator again and detailed report  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

- -- Joe Conway <mail@joeconway.com> wrote:

> Please try the attached patch and let me know how it works for you. It is
> against cvs HEAD, but should apply OK to 7.4.

so, I checked it with my database. 
It looks good, all checks I made are OK.


I realised, that converting my text column to bytea is much faster then
before:

UPDATE forum_gtree SET gid2 = (decode(replace(gid, '\\', '\\\\'),
'escape'));


This may be because some other side effects (but it's the same machine and
same disc, same partition), but also perhaps some changes in the patch ...


MANY THANKS!


When I'm back from WSIS I make the next try to change my application from
Base255-text to bytea ;-)


Ciao Alvar



- -- 
** Alvar C.H. Freude -- http://alvar.a-blast.org/ -- http://odem.org/
**   Berufsverbot? http://odem.org/aktuelles/staatsanwalt.de.html
**   ODEM.org-Tour: http://tour.odem.org/
**   Informationsgesellschaft: http://www.wsis-koordinierungskreis.de/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (FreeBSD)

iD8DBQE/0Tg6OndlH63J86wRAiLfAJ98wLJeeyEuFXG07Pa7ba/jM7LzxQCgzWa1
RGv3FtQ8JP/MZjCWuqbdnsY=
=U9Ng
-----END PGP SIGNATURE-----



pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: 7.4.1 ... slight change of scheduale ...
Next
From: Tom Lane
Date:
Subject: Re: 7.4.1 ... slight change of scheduale ...