pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedindex selection problem
3+ messages / 2 participants
[nested] [flat]
* index selection problem
@ 2003-05-21 08:56 phd9110 <phd9110@cs.nchu.edu.tw>
0 siblings, 0 replies; 3+ messages in thread
From: phd9110 @ 2003-05-21 08:56 UTC (permalink / raw)
To: pgsql-sql
Hi
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.
If you have suggestions about this question , please e-mail me: phd9110@cs.nchu.edu.tw
Thanks in advance.
Kao Gonfong
National ChungHsing University , Taiwan
email: phd9110@cs.nchu.edu.tw
^ permalink raw reply [nested|flat] 3+ messages in thread
* Index Selection Problem
@ 2003-05-22 13:05 phd9110 <phd9110@cs.nchu.edu.tw>
0 siblings, 1 reply; 3+ messages in thread
From: phd9110 @ 2003-05-22 13:05 UTC (permalink / raw)
To: pgsql-sql
Hi
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.
If you have suggestions about this question , please e-mail me: phd9110@cs.nchu.edu.tw
Thanks in advance.
Kao Gonfong
National ChungHsing University , Taiwan
email: phd9110@cs.nchu.edu.tw
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Index Selection Problem
@ 2003-05-22 16:12 Josh Berkus <josh@agliodbs.com>
parent: phd9110 <phd9110@cs.nchu.edu.tw>
0 siblings, 0 replies; 3+ messages in thread
From: Josh Berkus @ 2003-05-22 16:12 UTC (permalink / raw)
To: phd9110 <phd9110@cs.nchu.edu.tw>; pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-05-22 16:12 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-21 08:56 index selection problem phd9110 <phd9110@cs.nchu.edu.tw>
2003-05-22 13:05 Index Selection Problem phd9110 <phd9110@cs.nchu.edu.tw>
2003-05-22 16:12 ` Re: Index Selection Problem Josh Berkus <josh@agliodbs.com>
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