Re: database encoding with index search problem

From: Richard Huxton <dev(at)archonet(dot)com>
To: wisan watcharinporn <maccran(at)hotmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: database encoding with index search problem
Date: 2005-08-16 08:23:58
Message-ID: 4301A29E.30703@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

wisan watcharinporn wrote:
> problem:
> how can i configure database that can correct in sorting name and using
> index scan in like 'xxxx%' search

I think you'll want to read the following then have a quick search of
the mailing list archives for "opclass" for some examples.
http://www.postgresql.org/docs/8.0/static/sql-createindex.html
http://www.postgresql.org/docs/8.0/static/indexes-opclass.html

HTH
--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Rae 2005-08-16 08:39:10 Re: Looking for a large database for testing
Previous Message Sebastian Hennebrueder 2005-08-16 08:23:56 Re: Looking for a large database for testing