Re: LC_COLLATE and index usage - Mailing list pgsql-general

From Ralph Graulich
Subject Re: LC_COLLATE and index usage
Date
Msg-id Pine.LNX.4.53.0305080223290.17769@shauny.shauny.de
Whole thread Raw
In response to Re: LC_COLLATE and index usage  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Hi Karsten,

> Question seconded (and tacit suggestion for a TODO item) on
> behalf of GnuMed (www.gnumed.org).

Depending on how your LIKE searches look like, you can use a little work
around, which improves speed dramatically. In case you need to search like
"<String>%", you can use a second table containing each possible
combination of the search string, a fixed length field and JOIN that
helper table.

So you can change your LIKE search to a search for a string of fixed
length.


Kind regards
... Ralph ...


pgsql-general by date:

Previous
From: Max Baker
Date:
Subject: Re: age() and date intervals
Next
From: Karsten Hilbert
Date:
Subject: Re: LC_COLLATE and index usage