X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4D4C952838 for ; Wed, 8 Jun 2005 15:54:08 -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 20213-04 for ; Wed, 8 Jun 2005 18:54:05 +0000 (GMT) Received: from mailgw.dmi.dk (mailgw.dmi.dk [130.226.71.185]) by svr1.postgresql.org (Postfix) with ESMTP id D9989528C1 for ; Wed, 8 Jun 2005 15:54:04 -0300 (ADT) Received: from localhost (localhost.dmi.dk [127.0.0.1]) by mailgw.dmi.dk (8.12.11/8.12.11/Debian-1) with ESMTP id j58Is5fL015615; Wed, 8 Jun 2005 18:54:05 GMT Received: from mailgw.dmi.dk ([127.0.0.1]) by localhost (mailgw.dmi.dk [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 15487-06; Wed, 8 Jun 2005 18:53:56 +0000 (GMT) Received: from postoffice.dmi.dk (postoffice.dmi.dk [130.226.64.60]) by mailgw.dmi.dk (8.12.11/8.12.11/Debian-1) with ESMTP id j58Irq4c015608; Wed, 8 Jun 2005 18:53:52 GMT Received: from localhost (localhost.dmi.dk [127.0.0.1]) by postoffice.dmi.dk (Postfix) with ESMTP id BAEC018048; Wed, 8 Jun 2005 18:53:52 +0000 (GMT) Received: from postoffice.dmi.dk ([127.0.0.1]) by localhost (postoffice.dmi.dk [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 17243-01-22; Wed, 8 Jun 2005 18:53:52 +0000 (GMT) Received: from localhost (webmail [130.226.71.186]) by postoffice.dmi.dk (Postfix) with ESMTP id 7FD581803F; Wed, 8 Jun 2005 18:53:52 +0000 (GMT) Received: from port161.ds1-aroe.adsl.cybercity.dk (port161.ds1-aroe.adsl.cybercity.dk [217.157.138.230]) by webmail.dmi.dk (IMP) with HTTP for ; Wed, 8 Jun 2005 20:53:52 +0200 Message-ID: <1118256832.42a73ec06b75c@webmail.dmi.dk> Date: Wed, 8 Jun 2005 20:53:52 +0200 From: Kim Bisgaard To: Tom Lane Cc: pgsql-performance@postgresql.org Subject: Re: full outer performance problem References: <42A6BC64.4010001@dmi.dk> <20050608121755.GB11464@wolff.to> <42A6E55C.4030203@dmi.dk> <3909.1118247781@sss.pgh.pa.us> In-Reply-To: <3909.1118247781@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.6 X-Originating-IP: 217.157.138.230 X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at dmi.dk X-Virus-Scanned: by amavisd-maia-1.0.0-rc5 (Debian) at dmi.dk X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200506/184 X-Sequence-Number: 12821 Quoting Tom Lane : > Kim Bisgaard writes: > > W.r.t. your rewrite of the query, I get this "ERROR: could not devise a > > query plan for the given query" but no further details - I will try google > > Which PG version are you using again? That should be fixed in 7.4.3 > and later. > > regards, tom lane > Its 7.4.1. I am in the process (may take a while yet) of installing 8.0.3 on the same hardware in order to have a parallel system. Time is a finite meassure :-) I must admit I would rather have the first query perform, that have this workaround function ;-) Regards, Kim.