Re: [SQL] Queries not using Index - Mailing list pgsql-general

From Christopher Kings-Lynne
Subject Re: [SQL] Queries not using Index
Date
Msg-id 001801c23329$82b8a590$0200a8c0@SOL
Whole thread Raw
In response to RES: [SQL] Queries not using Index  (Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>)
List pgsql-general
> This SELECT causes a sequention scan 'cause your index
> is not HASH type, but likely a BTREE one.
> BTREE index is to interval searches (station = 'SAMI4%')
> not precise searchs. (station = 'SAMI4').

In Postgres, the hash index is slow and inefficient (it's a bit better
in7.3), and I believe btree is generally recommended over hash even for '='
instances.

Chris



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: need help : how to replace / extend existing SQL operators ?
Next
From: Elielson Fontanezi
Date:
Subject: RES: RES: [SQL] Queries not using Index