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 893879DC99B for ; Thu, 19 Jan 2006 12:53:12 -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 53817-04 for ; Thu, 19 Jan 2006 12:53:10 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from barracuda1.biscit.net (barracuda0-tel.biscit.net [82.195.96.18]) by postgresql.org (Postfix) with ESMTP id DC2A69DC889 for ; Thu, 19 Jan 2006 12:53:09 -0400 (AST) X-ASG-Debug-ID: 1137689589-31940-61-0 X-Barracuda-URL: http://82.195.96.18:80/cgi-bin/mark.cgi Received: from web1-glo.biscit.net (web1-glo.biscit.net [82.195.96.53]) by barracuda1.biscit.net (Spam Firewall) with ESMTP id 27C9014E112 for ; Thu, 19 Jan 2006 16:53:09 +0000 (GMT) Received: from bolek.coachhouse ([62.7.150.137]) by web1-glo.biscit.net (8.10.2/8.10.2) with ESMTP id k0JGr5i05951 for ; Thu, 19 Jan 2006 16:53:05 GMT Received: (Exim 3.36) #1 (Debian)) protocol: esmtp id 1EzcrO-0002Q4-00 ; Thu, 19 Jan 2006 16:42:06 +0000 Message-ID: <43CFC15C.7010808@numerixtechnology.de> Date: Thu, 19 Jan 2006 16:42:04 +0000 From: T E Schmitz Reply-To: mailreg@numerixtechnology.de User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql X-ASG-Orig-Subj: Re: [SQL] indexing for left join Subject: Re: indexing for left join References: <43CFB325.9060306@numerixtechnology.de> <1137686229.15377.303.camel@home> In-Reply-To: <1137686229.15377.303.camel@home> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by Biscit Outgoing Spam Firewall at biscit.net X-Barracuda-Spam-Score: 0.00 X-Barracuda-Spam-Status: No, SCORE=0.00 using global scores of TAG_LEVEL=1000.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=7.0 tests= X-Barracuda-Spam-Report: Code version 3.02, rules version 3.0.7556 Rule breakdown below pts rule name description ---- ---------------------- -------------------------------------------------- X-Barracuda-Rcpt: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.06 required=5 tests=[AWL=0.060] X-Spam-Score: 0.06 X-Spam-Level: X-Archive-Number: 200601/135 X-Sequence-Number: 23924 Rod Taylor wrote: >>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). Thanks for your responses. -- Regards, Tarlika Elisabeth Schmitz