X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8D574475A1E for ; Fri, 7 Feb 2003 09:55:29 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id C373C4759AF for ; Fri, 7 Feb 2003 09:55:28 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h17EtF5u026719; Fri, 7 Feb 2003 09:55:15 -0500 (EST) To: jeandre@itvs.co.za Cc: pgsql-performance@postgresql.org Subject: Re: Performance In-reply-to: References: Comments: In-reply-to jeandre@itvs.co.za message dated "Fri, 07 Feb 2003 10:11:46 +0200" Date: Fri, 07 Feb 2003 09:55:14 -0500 Message-ID: <26718.1044629714@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/34 X-Sequence-Number: 1090 jeandre@itvs.co.za writes: > ... does the order of tables in the from > clause make a difference in speed No, it does not; except perhaps in corner cases where two tables have exactly the same statistics, so that the planner has no basis for choosing one over the other. (This scenario could happen if you've never ANALYZEd either, for example.) > and how does indexing work on Postgres? Uh, it indexes. What's your question exactly? regards, tom lane