| From: | Einar Karttunen <ekarttun(at)cs(dot)Helsinki(dot)FI> |
|---|---|
| To: | Gabriel Fernandez <gabi(at)unica(dot)edu> |
| Cc: | PostgreSQL-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: What kind of index should I use ? |
| Date: | 2001-05-18 11:16:42 |
| Message-ID: | Pine.LNX.4.30.0105181415450.15389-100000@melkinpaasi.cs.Helsinki.FI |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 18 May 2001, Gabriel Fernandez wrote:
> Hi,
>
> I have a table with a lot of fields and I would want to obtain a quicker
> query response.
>
> The main characteristics are:
>
> The table is NOT often updated, I mean INSERT and UPDATE are sporadic
> sentences, but SELECT sentences are often executed.
>
> The most used query is something like
>
> select distinct field1 from my_table where field1 is not null and field2
> like '...'
>
> Should I use a BTREE index or would be better to use a HASH or RTREE ?
>
> Thanks,
>
> Gabi :-)
>
Use always a btree. The other algorithms are not implemented as well as
btree.
- Einar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alejandro Fernandez | 2001-05-18 11:47:37 | Re: Web Hosting That Supports PostgreSQL |
| Previous Message | Gabriel Fernandez | 2001-05-18 10:58:00 | What kind of index should I use ? |