Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 868E4B5DBD9 for ; Tue, 16 Aug 2011 14:43:50 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 17904-02 for ; Tue, 16 Aug 2011 17:43:44 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og121.obsmtp.com (exprod7og121.obsmtp.com [64.18.2.20]) by mail.postgresql.org (Postfix) with ESMTP id 86277B5DBE5 for ; Tue, 16 Aug 2011 14:43:43 -0300 (ADT) Received: from mail-fx0-f54.google.com ([209.85.161.54]) (using TLSv1) by exprod7ob121.postini.com ([64.18.6.12]) with SMTP ID DSNKTkqsTjySbWSEAgMZjMPueGLLBpVXV8WT@postini.com; Tue, 16 Aug 2011 10:43:43 PDT Received: by fxe4 with SMTP id 4so196369fxe.13 for ; Tue, 16 Aug 2011 10:43:41 -0700 (PDT) Received: by 10.223.89.139 with SMTP id e11mr2119451fam.85.1313516621250; Tue, 16 Aug 2011 10:43:41 -0700 (PDT) Received: from [192.168.1.183] (dsl-hkibrasgw2-ff7ac300-240.dhcp.inet.fi [88.195.122.240]) by mx.google.com with ESMTPS id i16sm196449faa.21.2011.08.16.10.43.38 (version=TLSv1/SSLv3 cipher=OTHER); Tue, 16 Aug 2011 10:43:39 -0700 (PDT) Message-ID: <4E4AAC49.7070401@enterprisedb.com> Date: Tue, 16 Aug 2011 20:43:37 +0300 From: Heikki Linnakangas User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; fi-FI; rv:1.9.2.18) Gecko/20110626 Icedove/3.1.11 MIME-Version: 1.0 To: Alexander Korotkov CC: Robert Haas , pgsql-hackers Subject: Re: WIP: Fast GiST index build References: <4E31D03D.70206@enterprisedb.com> <4E3977D8.1020506@enterprisedb.com> <4E3FAB1D.1060105@enterprisedb.com> <4E42DFCE.3050904@enterprisedb.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201108/791 X-Sequence-Number: 193546 Why is there ever a buffer on the root node? It seems like a waste of time to load N tuples from the heap into the root buffer, only to empty the buffer after it fills up. You might as well pull tuples directly from the heap. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com