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 F2DAF3A4D34 for ; Sat, 22 Jan 2005 01:09:40 +0000 (GMT) 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 44485-01 for ; Sat, 22 Jan 2005 01:09:33 +0000 (GMT) Received: from mailhost.ics.forth.gr (mailhost.ics.forth.gr [139.91.157.50]) by svr1.postgresql.org (Postfix) with ESMTP id BB4873A4B17 for ; Sat, 22 Jan 2005 01:09:34 +0000 (GMT) Received: from mailhost.ics.forth.gr (nemesis.ics.forth.gr [139.91.157.50]) by mailhost.ics.forth.gr (8.12.10/ICS-FORTH/V10-Server-1.0) with SMTP id j0M19PAT014828; Sat, 22 Jan 2005 03:09:30 +0200 (EET) Received: (from ASSP-nospam [127.0.0.1]) by mailhost.ics.forth.gr (SAVSMTP 3.1.0.29) with SMTP id M2005012203092901517 ; Sat, 22 Jan 2005 03:09:29 +0200 Received: from 139.91.82.28 ([139.91.82.28] helo=ourania.ics.forth.gr) by ASSP-nospam ; 22 Jan 05 01:09:29 -0000 Received: from ourania.ics.forth.gr (localhost [127.0.0.1]) by ourania.ics.forth.gr (8.12.10+Sun/8.12.2) with ESMTP id j0M19TXD006111; Sat, 22 Jan 2005 03:09:29 +0200 (EET) Received: from localhost (theohari@localhost) by ourania.ics.forth.gr (8.12.10+Sun/8.12.2/Submit) with ESMTP id j0M19SO4006108; Sat, 22 Jan 2005 03:09:29 +0200 (EET) Date: Sat, 22 Jan 2005 03:09:28 +0200 (EET) From: Ioannis Theoharis To: Greg Stark Cc: ken , pgsql-performance@postgresql.org Subject: Re: inheritance performance In-Reply-To: <87hdlaahez.fsf@stark.xeocode.com> Message-ID: References: <1106295545.6622.266.camel@pesky.s6portland> <87hdlaahez.fsf@stark.xeocode.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.28 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200501/404 X-Sequence-Number: 10094 On Fri, 21 Jan 2005, Greg Stark wrote: > There's also a slight performance hit because there's an optimization that the > planner does normally for simple queries that isn't currently done for either > UNION ALL or inherited tables. I think it's planned to fix that soon. Can you explain me in more details what kind of optimization is missing in that case?