From: Rohit Gaddi <rohitgaddi@yahoo.co.in>
To: pgsql-performance@postgresql.org
Subject: index selection by query planner
Date: Tue, 21 Jun 2005 08:48:50 +0100 (BST)
Message-ID: <20050621074855.77673.qmail@web8306.mail.in.yahoo.com> (raw)
Hi,
I have a table with two indices on the same column, one of which is a partial index. I would like the query planner to use the partial index whenever the query condition lies in the range of the partial index as it would yield better performance. Is there any way to enforce the ordering for the indices? How does the query planner decide which index to use when a particular query is fired? 'Explain Analyze' showed the total index being used in a situation that could be fulfiled by the partial index.
Thanks,
Rohit
---------------------------------
How much free photo storage do you get? Store your friends n family photos for FREE with Yahoo! Photos.
http://in.photos.yahoo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rohitgaddi@yahoo.co.in
Subject: Re: index selection by query planner
In-Reply-To: <20050621074855.77673.qmail@web8306.mail.in.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox