From: Jaime Casanova <systemguards@gmail.com>
To: Jim C. Nasby <decibel@decibel.org>
Cc: Heikki Linnakangas <heikki@enterprisedb.com>
Cc: Pavan Deolasee <pavan.deolasee@gmail.com>
Cc: PostgreSQL-patches <pgsql-patches@postgresql.org>
Subject: Re: Maintaining cluster order on insert
Date: Sat, 16 Jun 2007 04:48:46 +0000
Message-ID: <c2d9e70e0706152148h7824eaafh499ba536eec82149@mail.gmail.com> (raw)
In-Reply-To: <20070527190136.GR92628@nasby.net>
References: <464A33AB.1050401@enterprisedb.com>
<464B15EF.4000808@enterprisedb.com>
<c2d9e70e0705172153g3207adb6kd4abdfdf3a9215ff@mail.gmail.com>
<464D96D6.1030608@enterprisedb.com>
<c2d9e70e0705182205o44a4bbbft18a73b9de91de726@mail.gmail.com>
<464F410C.8090900@enterprisedb.com>
<2e78013d0705210117y6a65245cw426bbaafa9eb6419@mail.gmail.com>
<2e78013d0705210232m5d031a6fk779be6d7df5a2e3c@mail.gmail.com>
<46516B0B.3000907@enterprisedb.com>
<20070527190136.GR92628@nasby.net>
On 5/27/07, Jim C. Nasby <decibel@decibel.org> wrote:
> On Mon, May 21, 2007 at 10:48:59AM +0100, Heikki Linnakangas wrote:
> >
> > IOW it's working as designed. But maybe it's not the desired behavior.
> > Should we have a special case and always respect the fillfactor when
> > inserting to the last page of the heap?
>
> I think that would be following with least surprise.
What's the status of this patch? are we waiting an update?
AFAIU, it's not fair to say that the patch maintain cluster order...
it just try to keep similar rows on the same page if possible (it's
not the same thing)... if it can't then it simply insert at the last
page as usual but we have wasted time in the try...
so the real question is if there is any performance win on this...
have you some numbers?
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?
--
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: systemguards@gmail.com, decibel@decibel.org, heikki@enterprisedb.com, pavan.deolasee@gmail.com, pgsql-patches@postgresql.org
Subject: Re: Maintaining cluster order on insert
In-Reply-To: <c2d9e70e0706152148h7824eaafh499ba536eec82149@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox