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 07EB03A4D34 for ; Sat, 22 Jan 2005 04:22:27 +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 74787-03 for ; Sat, 22 Jan 2005 04:22:17 +0000 (GMT) Received: from stark.xeocode.com (gsstark.mtl.istop.com [66.11.160.162]) by svr1.postgresql.org (Postfix) with ESMTP id F3DE83A4C18 for ; Sat, 22 Jan 2005 04:22:16 +0000 (GMT) Received: from localhost ([127.0.0.1] helo=stark.xeocode.com) by stark.xeocode.com with smtp (Exim 3.36 #1 (Debian)) id 1CsCmr-0003jj-00; Fri, 21 Jan 2005 23:22:13 -0500 To: Ioannis Theoharis Cc: Greg Stark , ken , pgsql-performance@postgresql.org Subject: Re: inheritance performance References: <1106295545.6622.266.camel@pesky.s6portland> <87hdlaahez.fsf@stark.xeocode.com> In-Reply-To: From: Greg Stark Organization: The Emacs Conspiracy; member since 1992 Date: 21 Jan 2005 23:22:13 -0500 Message-ID: <87pszy6qkq.fsf@stark.xeocode.com> Lines: 17 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 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.056 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/408 X-Sequence-Number: 10098 Ioannis Theoharis writes: > Can you explain me in more details what kind of optimization is missing in > that case? Uh, no I can't really. It was mentioned on the mailing list with regards to UNION ALL specifically. I think it applied to inherited tables as well but I wouldn't know for sure. You could search the mailing list archives for recent discussions of partitioned tables. In any acse it was a purely technical detail. Some step in the processing of the data that could be skipped if there weren't any actual changes to the data being done or something like that. It made a small but noticeable difference in the runtime but nothing that made the technique infeasible. -- greg