On 18.04.2006, at 17:16 Uhr, Tarabas (Manuel Rorarius) wrote:
> Is there any way to speed the like's up with a different locale than C
> or to get an order by in a different Locale although using the
> default C locale?
Sure. Just create the index with
create index <tabname>_<column>_index on <tabname> (<column>
Than you can use something like
select * from <table> where <column> like 'Something%';
Remember that an index can't be used for queries with '%pattern%'.
In response to
pgsql-performance by date
|Next:||From: Tarabas (Manuel Rorarius)||Date: 2006-04-18 15:43:53|
|Subject: Re: [bulk] RE: Problem with LIKE-Performance|
|Previous:||From: Hakan Kocaman||Date: 2006-04-18 15:35:30|
|Subject: Re: Problem with LIKE-Performance|