X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5C097D8E04 for ; Tue, 13 Sep 2005 22:34:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34993-08 for ; Wed, 14 Sep 2005 01:34:51 +0000 (GMT) Received: from mailbox.samurai.com (mailbox.samurai.com [205.207.28.82]) by svr1.postgresql.org (Postfix) with ESMTP id CFE30D8E03 for ; Tue, 13 Sep 2005 22:34:51 -0300 (ADT) Received: from localhost (mailbox.samurai.com [205.207.28.82]) by mailbox.samurai.com (Postfix) with ESMTP id C7A3F239795; Tue, 13 Sep 2005 21:34:55 -0400 (EDT) Received: from mailbox.samurai.com ([205.207.28.82]) by localhost (mailbox.samurai.com [205.207.28.82]) (amavisd-new, port 10024) with LMTP id 04666-01-10; Tue, 13 Sep 2005 21:34:51 -0400 (EDT) Received: from [192.168.1.101] (d226-86-55.home.cgocable.net [24.226.86.55]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mailbox.samurai.com (Postfix) with ESMTP id 30580239797; Tue, 13 Sep 2005 21:34:51 -0400 (EDT) Message-ID: <43277E3A.7070703@samurai.com> Date: Tue, 13 Sep 2005 21:34:50 -0400 From: Neil Conway User-Agent: Mozilla Thunderbird 1.0.2 (Macintosh/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Cristian Prieto Cc: pryscila.lista@gmail.com, pgsql-performance@postgresql.org Subject: Re: About method of PostgreSQL's Optimizer References: <013601c5b8bb$564f7450$6500a8c0@gt.ClickDiario.local> In-Reply-To: <013601c5b8bb$564f7450$6500a8c0@gt.ClickDiario.local> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at mailbox.samurai.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200509/182 X-Sequence-Number: 14490 Cristian Prieto wrote: > Anyway, do you know where could I get more info and theory about > database optimizer plan? (in general) Personally I like this survey paper on query optimization: http://citeseer.csail.mit.edu/371707.html The paper also cites a lot of other papers that cover specific techniques in more detail. -Neil