X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 630FD9FA4D8 for ; Thu, 8 Jun 2006 13:42:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 79566-02 for ; Thu, 8 Jun 2006 13:42:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.177]) by postgresql.org (Postfix) with ESMTP id 8ABBF9FA1A4 for ; Thu, 8 Jun 2006 13:42:28 -0300 (ADT) Received: from [84.143.10.74] (helo=pse.dyndns.org) by mrelayeu.kundenserver.de (node=mrelayeu3) with ESMTP (Nemesis), id 0MKxQS-1FoNaV1BDg-0001WO; Thu, 08 Jun 2006 18:42:27 +0200 Received: from pse1 ([192.168.0.3]) by pse.dyndns.org with esmtp (Exim 4.44) id 1FoNaU-0006z7-9Z; Thu, 08 Jun 2006 18:42:26 +0200 Message-ID: <44885371.5020201@pse-consulting.de> Date: Thu, 08 Jun 2006 18:42:25 +0200 From: Andreas Pflug User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane CC: pgsql-performance@postgresql.org Subject: Re: JOIN with inherited table ignores indexes References: <44880CB1.90307@pse-consulting.de> <28435.1149782785@sss.pgh.pa.us> In-Reply-To: <28435.1149782785@sss.pgh.pa.us> X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: kundenserver.de abuse@kundenserver.de login:0ce7ee5c3478b8d72edd8e05ccd40b70 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/96 X-Sequence-Number: 19453 Tom Lane wrote: > Andreas Pflug writes: > >>Any explanation for this horror? > > > Existing releases aren't smart about planning joins to inheritance > trees. Using a view that UNIONs SELECT .. ONLY as replacement for the parent table isn't any better. Is that improved too? > CVS HEAD is better... Customers like HEAD versions for production purposes :-) Regards, Andreas