From: Josh Berkus <josh@agliodbs.com>
To: phd9110 <phd9110@cs.nchu.edu.tw>
To: pgsql-sql@postgresql.org
Subject: Re: Index Selection Problem
Date: Thu, 22 May 2003 09:12:36 -0700
Message-ID: <200305220912.36681.josh@agliodbs.com> (raw)
In-Reply-To: <003001c32062$e0444440$ea0f788c@husky>
References: <003001c32062$e0444440$ea0f788c@husky>
M. Gonfong (or M. Kao?)
> I and my lab is interesting in the index selection problem.
> Is there any index selection tools ( like MS SQL Server index tuning wizard
> ) in postgresql ? Is there any project about this problem which is going
> If we want to develop this tool , what document i should read. or where i
> can get more support.
Check out the developer web site:
http://developer.postgresql.org
There is documentation there to give you an overview of the PostgreSQL
internals.
Unlike SQL Server, PostgreSQL does not permit "index hints" in queries.
Postgres' philosophy, to date, has been to improve the query planner as much
as possible and to focus on whole-database tuning tools rather than giving
users ways to override the planner on a per-query basis. (Am I getting this
right, Tom?)
That being said, I know the team could use some help in improving the
planner's behavior, for example in the selectivity of subselects in the WHERE
clause. If you are interested in contributing to the project, join the
PGSQL-HACKERS mailing list and propose your patch there.
--
Josh Berkus
Aglio Database Solutions
San Francisco
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-sql@postgresql.org
Cc: josh@agliodbs.com, phd9110@cs.nchu.edu.tw
Subject: Re: Index Selection Problem
In-Reply-To: <200305220912.36681.josh@agliodbs.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