From alice_lottini@yahoo.it Mon Jun 8 11:40:37 2026 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 695A74766C8 for ; Tue, 22 Oct 2002 10:16:18 -0400 (EDT) Received: from smtp016.mail.yahoo.com (smtp016.mail.yahoo.com [216.136.174.113]) by postgresql.org (Postfix) with SMTP id 9D35C4766B0 for ; Tue, 22 Oct 2002 10:16:12 -0400 (EDT) Received: from tullimonstrum.polito.it (HELO Tullimonstrum) (alice?lottini@130.192.5.57 with login) by smtp.mail.vip.sc5.yahoo.com with SMTP; 22 Oct 2002 14:16:16 -0000 Message-ID: <002701c279d5$8bc03660$3905c082@Tullimonstrum> From: "Alice Lottini" To: , Subject: looking for documentation about the optimizer Date: Tue, 22 Oct 2002 16:15:57 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0024_01C279E6.4DC04380" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/21 X-Sequence-Number: 1515 This is a multi-part message in MIME format. ------=_NextPart_000_0024_01C279E6.4DC04380 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I'm a student in Informatics Engineering and I'm working at my thesis, for = which I have to integrate one or more primitives in PostgreSQL in order to = support data mining algorithms; this task firstly requires a deep analysis = on the PostgreSQL optimizer (the way it works and its source code). Does anybody know where I can find some documentation about the PostgreSQL = optimizer? I've read some old messages (1997) about an "Implementation Guide" but the = related link seems to be obsolete ("page not found")... Any suggestion is welcome! thanks in advance, alice ------=_NextPart_000_0024_01C279E6.4DC04380 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

I'm a student in Informatics Eng= ineering=20 and I'm working at my thesis, for which I have to integrate one o= r=20 more primitives in PostgreSQL in order to support data mining algorithms; t= his=20 task firstly requires a deep analysis on the PostgreSQL optimizer (the way = it=20 works and its source code).

Does anybody know where I can find some=20 documentation about the PostgreSQL optimizer?

I've read some old messages (1997) about a= n=20 "Implementation Guide" but the related link seems to be obsolete ("page not= =20 found")...

Any suggestion is welcome!

thanks in advance, alice

------=_NextPart_000_0024_01C279E6.4DC04380-- ______________________________________________________________________ Scarica il nuovo Yahoo! Messenger: con webcam, nuove faccine e tante altre novità. http://it.yahoo.com/mail_it/foot/?http://it.messenger.yahoo.com/ From tgl@sss.pgh.pa.us Mon Jun 8 11:40:37 2026 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2054547616D; Tue, 22 Oct 2002 10:49:05 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 5B6CA47614E; Tue, 22 Oct 2002 10:49:04 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g9MEn8hR018935; Tue, 22 Oct 2002 10:49:08 -0400 (EDT) To: "Alice Lottini" Cc: pgsql-general@postgresql.org, pgsql-docs@postgresql.org Subject: Re: looking for documentation about the optimizer In-reply-to: <002701c279d5$8bc03660$3905c082@Tullimonstrum> References: <002701c279d5$8bc03660$3905c082@Tullimonstrum> Comments: In-reply-to "Alice Lottini" message dated "Tue, 22 Oct 2002 16:15:57 +0200" Date: Tue, 22 Oct 2002 10:49:08 -0400 Message-ID: <18934.1035298148@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/22 X-Sequence-Number: 1516 "Alice Lottini" writes: > Does anybody know where I can find some documentation about the PostgreSQL = > optimizer? Aside from the general info in the Developer's Guide, there are README files in the source tree that you should look at: src/backend/optimizer/README src/backend/optimizer/plan/README After that, start reading the code ... regards, tom lane From pgman@candle.pha.pa.us Mon Jun 8 11:40:37 2026 Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8E2874762A1; Tue, 22 Oct 2002 13:06:53 -0400 (EDT) Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251]) by postgresql.org (Postfix) with ESMTP id 4062947628C; Tue, 22 Oct 2002 13:06:51 -0400 (EDT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id g9MH6EC07697; Tue, 22 Oct 2002 13:06:14 -0400 (EDT) From: Bruce Momjian Message-Id: <200210221706.g9MH6EC07697@candle.pha.pa.us> Subject: Re: looking for documentation about the optimizer In-Reply-To: <18934.1035298148@sss.pgh.pa.us> To: Tom Lane Date: Tue, 22 Oct 2002 13:06:14 -0400 (EDT) Cc: Alice Lottini , pgsql-general@postgresql.org, pgsql-docs@postgresql.org X-Mailer: ELM [version 2.4ME+ PL99 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/23 X-Sequence-Number: 1517 Tom Lane wrote: > "Alice Lottini" writes: > > Does anybody know where I can find some documentation about the PostgreSQL = > > optimizer? > > Aside from the general info in the Developer's Guide, there are README > files in the source tree that you should look at: > src/backend/optimizer/README > src/backend/optimizer/plan/README > After that, start reading the code ... And some papers on the web site in the Developer's Corner. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073