X-Original-To: pgsql-patches-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 10A919FB25E for ; Wed, 9 Aug 2006 17:47:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 62700-06 for ; Wed, 9 Aug 2006 20:47:33 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by postgresql.org (Postfix) with ESMTP id 35F459FB2F8 for ; Wed, 9 Aug 2006 17:47:32 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id m3so247635ugc for ; Wed, 09 Aug 2006 13:47:31 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=QTl3S+qp2ZgV7QIHcRAY7MzcYRamVhp7RU5ryqhOVwz8fvDUkSQbXU0pgsAszIhemO8kuO7YOkXhIwxrUfWnWpiNYbe9RdM5zqh9J9iYWYxRci49Rez5TAly38bFTy5FcH6+cdIQMd08mleSIn0ap6KQYp8O+Qmo3dP8PJvCeQw= Received: by 10.66.249.11 with SMTP id w11mr1468551ugh; Wed, 09 Aug 2006 13:47:31 -0700 (PDT) Received: by 10.67.32.9 with HTTP; Wed, 9 Aug 2006 13:47:31 -0700 (PDT) Message-ID: <36e682920608091347m4e075a8cv6a04e3c4d97ed6f4@mail.gmail.com> Date: Wed, 9 Aug 2006 16:47:31 -0400 From: "Jonah H. Harris" To: "Tom Lane" Subject: Re: Maintaining cluster order on insert Cc: pgsql-hackers@postgresql.org, "Heikki Linnakangas" , pgsql-patches@postgresql.org In-Reply-To: <28914.1155154622@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <44DA31B1.3090700@enterprisedb.com> <28914.1155154622@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.199 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/130 X-Sequence-Number: 20646 On 8/9/06, Tom Lane wrote: > UPDATE tries to place the new tuple on the same page it's already > on. I think he meant for INSERT. -- Jonah H. Harris, Software Architect | phone: 732.331.1300 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 2nd Floor | jharris@enterprisedb.com Iselin, New Jersey 08830 | http://www.enterprisedb.com/