Postgres Pro
Downloads
Home   >   mailing lists

Index is not used - Mailing list pgsql-admin

From A.Bhuvaneswaran
Subject Index is not used
Date
Msg-id 1071894514.1380.1.camel@Bhuvan.bksys.co.in
Whole thread Raw
Responses Re: Index is not used
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: incremental backup possible in 7.3 or 7.4?
Next
From: Tom Lane
Date:
Subject: Re: Index is not used