Re: Performance of DOMAINs

On Jun 21, 2006, at 18:19, Josh Berkus wrote:

> Well, current case-insensitivity hacks definitely aren't compatible
> with
> LIKE as far as "begins with" indexes are concerned.

Yes, currently I use LOWER() for my indexes and for all LIKE, =, etc.
queries. This works well, but ORDER by of course isn't what I'd like.
That's one of the things that Elein's email domain addresses, albeit
with a USING keyword, which is unfortunate.

> Of course, floating
> LIKEs (%value%) are going to suck no matter what data type you're
> using.

Yes, I know that. :-) I avoid that.

> I created an operator for CI equality ... =~ ... which performs
> well on
> indexed columns.   But it doesn't do "begins with".

Oops. So how could it perform well on indexed columns?

> ITEXT is a TODO, but there are reasons why it's harder than it looks.

I'm sure. I should bug potential future SoC students about it. ;-)

Best,

David