Re: Maintaining cluster order on insert - Mailing list pgsql-patches

From Pavan Deolasee
Subject Re: Maintaining cluster order on insert
Date
Msg-id 2e78013d0705210232m5d031a6fk779be6d7df5a2e3c@mail.gmail.com
Whole thread Raw
In response to Re: Maintaining cluster order on insert  ("Pavan Deolasee" <pavan.deolasee@gmail.com>)
Responses Re: Maintaining cluster order on insert  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-patches


On 5/21/07, Pavan Deolasee <pavan.deolasee@gmail.com> wrote:


On 5/19/07, Heikki Linnakangas < heikki@enterprisedb.com > wrote:

Ah, sorry about that. For some reason my source tree was checked out
from the 8.2 branch, instead of CVS HEAD.


I looked at the patch. Not that I am very comfortable with this part
of the code, but nevertheless here are my comments:


Another problem that I noticed with the patch is that it disregards
the fillfactor while inserting the tuples. ISTM that this is a correct
behavior when a tuple is being inserted in the block to preserve cluster
ordering. But when the tuple is being inserted as a normal operation,
IMO we should respect the fillfactor.

The easiest way to reproduce this is to insert tuples sorted on the
cluster index key.

Thanks,
Pavan


--

EnterpriseDB     http://www.enterprisedb.com

pgsql-patches by date:

Previous
From: "Pavan Deolasee"
Date:
Subject: Re: Maintaining cluster order on insert
Next
From: Heikki Linnakangas
Date:
Subject: Re: Maintaining cluster order on insert