partial index + select query performance

From: "petchimuthu lingam" <spmlingam(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: partial index + select query performance
Date: 2008-03-13 07:21:54
Message-ID: cd233fc30803130021h3dbfdea4m3db755677b2b14a0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I have created partial index on a field with conditions, if field _a > 200
and field_a < 300.

I using the select query with condition as field_a in ( 100, 250, 289, ),

Will it use the index.

--
With Best Regards,
Petchimuthulingam S

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message A. Kretschmer 2008-03-13 07:33:46 Re: partial index + select query performance
Previous Message Craig Ringer 2008-03-13 06:35:00 Re: Repeated execution of identical subqueries