Postgres Pro
Downloads
Home   >   mailing lists

partial index + select query performance - Mailing list pgsql-performance

From petchimuthu lingam
Subject partial index + select query performance
Date
Msg-id cd233fc30803130021h3dbfdea4m3db755677b2b14a0@mail.gmail.com
Whole thread Raw
Responses Re: partial index + select query performance  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-performance
Tree view

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

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Repeated execution of identical subqueries
Next
From: "A. Kretschmer"
Date:
Subject: Re: partial index + select query performance