indices - Mailing list pgsql-general

From Sandeep Joshi
Subject indices
Date
Msg-id 3A25ADE4.6830E134@zambeel.com
Whole thread Raw
In response to how to determine what a process is doing  (Alex Howansky <alex@wankwood.com>)
List pgsql-general
Hi,
   I had learned in theory that Hash indices are used for "=" and
B-tree for "<" ,">".

    explain command doesn't tell us which index it is using. Hash or
Btree?
Also,
    should a following query
     "id < 1243" invoke a index ? (assuming there is an index on id).

    I have seen Postgres using Seq scan. Is sequential scan done afer
getting the first
page for "1243"?

Sandeep

pgsql-general by date:

Previous
From: "Igor V. Rafienko"
Date:
Subject: Re: Unanswered questions about Postgre
Next
From: "Joel Burton"
Date:
Subject: Re: Unanswered questions about Postgre