Re: EXTERNAL storage and substring on long strings - Mailing list pgsql-performance

From Tom Lane
Subject Re: EXTERNAL storage and substring on long strings
Date
Msg-id 18763.1059683520@sss.pgh.pa.us
Whole thread Raw
In response to Re: EXTERNAL storage and substring on long strings  (Scott Cain <cain@cshl.org>)
List pgsql-performance
Scott Cain <cain@cshl.org> writes:
>> (BTW, if you are using a multibyte database encoding, then that's your
>> problem right there --- the optimization is practically useless unless
>> character and byte indexes are the same.)

> I shouldn't be, but since it is an RPM, I can't be sure.

Look at "psql -l" to see what encoding it reports for your database.

            regards, tom lane

pgsql-performance by date:

Previous
From: Joe Conway
Date:
Subject: Re: EXTERNAL storage and substring on long strings
Next
From: "Medora Schauer"
Date:
Subject: Odd performance results