From: Tobias Brox <tobias@nordicbet.com>
To: pgsql-performance@postgresql.org
Subject: Forcing use of specific index
Date: Thu, 2 Jun 2005 10:05:28 +0800
Message-ID: <20050602020528.GL26100@tobias.exoweb.net> (raw)
Is it any way to attempt to force the planner to use some specific index
while creating the plan? Other than eventually dropping all the other
indices (which is obiously not a solution in production setting anyway)?
I have one case where I have added 16 indices to a table, many of them
beeing partial indices. The table itself has only 50k of rows, but are
frequently used in heavy joins. I imagine there can be exponential order on
the number of alternative paths the planner must examinate as function of
the number of indices?
It seems to me that the planner is quite often not choosing the "best"
index, so I wonder if there is any easy way for me to check out what the
planner think about a specific index :-)
--
Tobias Brox, Beijing
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: tobias@nordicbet.com
Subject: Re: Forcing use of specific index
In-Reply-To: <20050602020528.GL26100@tobias.exoweb.net>
* 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