Index is not used

From: "A(dot)Bhuvaneswaran" <bhuvan(at)symonds(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Index is not used
Date: 2003-12-20 04:28:35
Message-ID: 1071894514.1380.1.camel@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I am using pgsql 7.3.4 on rh7.3.

I have a table and an index on it. The index is used when i use '='
operator for the indexed field in the where condition. But the index is
not used when i use '>=' operator for the same field. Herewith i have
attached the explain output. Hope to get some lights.

regards,
bhuvaneswaran

Attachment Content-Type Size
explain.txt text/plain 3.1 KB

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-12-20 04:39:03 Re: Index is not used
Previous Message Bruce Momjian 2003-12-20 00:09:15 Re: incremental backup possible in 7.3 or 7.4?