Re: Maintaining cluster order on insert

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jaime Casanova" <systemguards(at)gmail(dot)com>
Cc: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>, "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Maintaining cluster order on insert
Date: 2007-06-16 14:56:24
Message-ID: 11028.1182005784@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

"Jaime Casanova" <systemguards(at)gmail(dot)com> 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-06-16 15:02:33 Re: Load Distributed Checkpoints, revised patch
Previous Message Simon Riggs 2007-06-16 09:14:46 Re: [PATCHES] Load Distributed Checkpoints, revised patch

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-06-16 15:02:33 Re: Load Distributed Checkpoints, revised patch
Previous Message Simon Riggs 2007-06-16 09:14:46 Re: [PATCHES] Load Distributed Checkpoints, revised patch