Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4A59B9FB370 for ; Sat, 16 Jun 2007 13:55:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 49877-10 for ; Sat, 16 Jun 2007 13:55:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.241]) by postgresql.org (Postfix) with ESMTP id C831B9FB337 for ; Sat, 16 Jun 2007 13:55:48 -0300 (ADT) Received: by an-out-0708.google.com with SMTP id c36so251844ana for ; Sat, 16 Jun 2007 09:55:48 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=NgCAdGcPMx3iUEch8KPGTZxSQA1gk4UvXItsAubypTQ1qoBHsvGfN6ewqZQ/krt9/ATZmvDJSQAB3wIMUYSq166bZfSbvFTD227mtCUvyk0y3+pF1P+PpSKne7XMGyhQue0/ULCbnTqBBSO/La4oW1KwZH0SlCXkcdPOoXAvqPs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=m3xHC4Zm0vUp9Kf7u03DiIHzIcq0xbIH0EUzi9UmOqSuj4KMT8XdxAyEgFJypIJV0sFLfebtVkhr0GTiF4/QIpR+3kWjVc0CWzBB+vafXnO2xO/ONjgWuwzxfd7kYnxxtBVnqyL8MjWz4mR1yLSFZPx6A2aOUKlMVF38PqXYFUc= Received: by 10.100.106.5 with SMTP id e5mr15030anc.1182012947964; Sat, 16 Jun 2007 09:55:47 -0700 (PDT) Received: by 10.100.45.15 with HTTP; Sat, 16 Jun 2007 09:55:47 -0700 (PDT) Message-ID: Date: Sat, 16 Jun 2007 16:55:47 +0000 From: "Jaime Casanova" To: "Tom Lane" Subject: Re: Maintaining cluster order on insert Cc: "Jim C. Nasby" , "Heikki Linnakangas" , "Pavan Deolasee" , PostgreSQL-patches In-Reply-To: <11028.1182005784@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: <464A33AB.1050401@enterprisedb.com> <464D96D6.1030608@enterprisedb.com> <464F410C.8090900@enterprisedb.com> <2e78013d0705210117y6a65245cw426bbaafa9eb6419@mail.gmail.com> <2e78013d0705210232m5d031a6fk779be6d7df5a2e3c@mail.gmail.com> <46516B0B.3000907@enterprisedb.com> <20070527190136.GR92628@nasby.net> <11028.1182005784@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/165 X-Sequence-Number: 2781 On 6/16/07, Tom Lane wrote: > "Jaime Casanova" writes: > > another question: if the fillfactor is 100% then is a complete waste > > of time to look for a suggested block. maybe we could check for that? > > No, it isn't, since the page might have been vacuumed since it was last > filled up. > > regards, tom lane > ahh... that vacuum thing!!! yeah!!! ;) -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning." Richard Cook