X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 26018D1B4E1 for ; Mon, 29 Sep 2003 13:45:44 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 88672-02 for ; Mon, 29 Sep 2003 10:45:16 -0300 (ADT) Received: from durian.pingpong.net (81.milagro.bahnhof.net [195.178.168.81]) by svr1.postgresql.org (Postfix) with ESMTP id 6F4C8D1B51D for ; Mon, 29 Sep 2003 10:45:10 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by durian.pingpong.net (8.12.8p1/8.12.8) with ESMTP id h8TDj2Oj001297 for ; Mon, 29 Sep 2003 15:45:02 +0200 (CEST) (envelope-from girgen@pingpong.net) Date: Mon, 29 Sep 2003 15:45:02 +0200 From: Palle Girgensohn To: pgsql-performance@postgresql.org Subject: Re: avoiding seqscan? Message-ID: <202370000.1064843102@durian.pingpong.net> X-Mailer: Mulberry/3.0.3 (Linux/x86) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; FORMAT=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/352 X-Sequence-Number: 3718 --On m=E5ndag, september 29, 2003 15.32.31 +0200 Gaetano Mendola=20 wrote: > Are not absolutelly bad but sometimes that path that you choose is not > the optimal, in postgres 7.4 use the explicit join will be less > limitative for the planner. > > Regards > Gaetano Mendola Ah, OK. True! In this case though, the sql questions are crafted with great= =20 care, since we have a lot of data in a few of the tables, other are almost= =20 empty, so we try to limit the amount of data as early as possible. Our=20 experience says that we often do a better job than the planner, since we=20 know which tables are "fat". Hence, we have actually moved to exlicit joins= =20 in questions and sometimes gained speed. But, in the general case, implicit might be better, I guess. Regards, Palle