X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 92BBE9DCA06 for ; Thu, 19 Jan 2006 11:57:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40216-10 for ; Thu, 19 Jan 2006 11:57:12 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from keymaster.look.ca (delta1.look.ca [207.136.80.9]) by postgresql.org (Postfix) with ESMTP id DF1E69DCA25 for ; Thu, 19 Jan 2006 11:57:05 -0400 (AST) Received: from 209-161-193-179.dsl.look.ca ([209.161.193.179]) by keymaster.look.ca with esmtp (Exim 4.20) id 1Ezc9v-00087u-Bz; Thu, 19 Jan 2006 15:57:11 +0000 From: Rod Taylor To: mailreg@numerixtechnology.de Cc: pgsql-sql In-Reply-To: <43CFB325.9060306@numerixtechnology.de> References: <43CFB325.9060306@numerixtechnology.de> Date: Thu, 19 Jan 2006 10:57:09 -0500 Message-Id: <1137686229.15377.303.camel@home> Mime-Version: 1.0 X-Mailer: Evolution 2.4.2.1 FreeBSD GNOME Team Port X-SA-Exim-Mail-From: pg@rbt.ca Subject: Re: indexing for left join Content-Type: text/plain Content-Transfer-Encoding: 7bit X-SA-Exim-Version: 3.1 (built Tue Feb 24 05:09:27 GMT 2004) X-SA-Exim-Scanned: Yes X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200601/131 X-Sequence-Number: 23920 > Sequential despite the indices? Or is this because the tables of my test > DB are virtually empty? This is it. PostgreSQL changes strategies with data load. Performance testing must be done on an approximation of the real data (both values and size). --