email: phd9110@cs.nchu.edu.tw ------=_NextPart_000_0005_01C31FB9.E9450010-- From phd9110@cs.nchu.edu.tw Thu May 22 13:07:01 2003 X-Original-To: pgsql-sql@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 2A0F0926F39 for ; Thu, 22 May 2003 09:07:01 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 00766-01 for ; Thu, 22 May 2003 09:06:29 -0400 (EDT) Received: from angelica.cs.nchu.edu.tw (angelica.cs.nchu.edu.tw [140.120.13.7]) by developer.postgresql.org (Postfix) with ESMTP id 59D79926F36 for ; Thu, 22 May 2003 09:06:27 -0400 (EDT) Received: from flute.cs.nchu.edu.tw (flute [140.120.13.3]) by angelica.cs.nchu.edu.tw (8.11.7+Sun/8.11.7) with ESMTP id h4MD32s24867 for ; Thu, 22 May 2003 21:03:02 +0800 (CST) Received: from husky ([140.120.15.234]) by flute.cs.nchu.edu.tw (8.11.7+Sun/8.11.7) with SMTP id h4MDD7n15728 for ; Thu, 22 May 2003 21:13:08 +0800 (CST) Message-ID: <003001c32062$e0444440$ea0f788c@husky> From: "phd9110" To: Subject: Index Selection Problem Date: Thu, 22 May 2003 21:05:53 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002D_01C320A5.EDF9F560" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/413 X-Sequence-Number: 13578 This is a multi-part message in MIME format. ------=_NextPart_000_002D_01C320A5.EDF9F560 Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: quoted-printable 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 c= an 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 ------=_NextPart_000_002D_01C320A5.EDF9F560 Content-Type: text/html; charset="big5" Content-Transfer-Encoding: quoted-printable

I and my lab is interesting in the index sele= ction=20 problem.

Is there any index selection tools ( like MS SQL S= erver=20 index tuning wizard ) in postgresql ?

Is there any project about this proble= m which=20 is going

If we want to develop this tool , what docume= nt=20 i should read. or where i can get more=20 support.

If you have suggestions about this question , ple= ase=20 e-mail me: phd9110@cs.nchu.edu.tw
Thanks i= n=20 advance.

Kao Gonfong

National ChungHsing University , Taiwan

email: phd9110@cs.nchu.edu.tw

------=_NextPart_000_002D_01C320A5.EDF9F560-- From josh@agliodbs.com Thu May 22 17:29:59 2003 X-Original-To: pgsql-sql@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 213F3924C12 for ; Thu, 22 May 2003 13:29:59 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 50201-05 for ; Thu, 22 May 2003 13:29:27 -0400 (EDT) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by developer.postgresql.org (Postfix) with ESMTP id 6CDE59255FE for ; Thu, 22 May 2003 12:14:02 -0400 (EDT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3056002; Thu, 22 May 2003 09:14:02 -0700 Content-Type: text/plain; charset="big5" From: Josh Berkus Organization: Aglio Database Solutions To: "phd9110" , Subject: Re: Index Selection Problem Date: Thu, 22 May 2003 09:12:36 -0700 User-Agent: KMail/1.4.3 References: <003001c32062$e0444440$ea0f788c@husky> In-Reply-To: <003001c32062$e0444440$ea0f788c@husky> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200305220912.36681.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/420 X-Sequence-Number: 13585 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