Re: Maintaining cluster order on insert

From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 16:55:47
Message-ID: c2d9e70e0706160955t4851efd3hfebdb8df7b6b5468@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On 6/16/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "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
>

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-06-16 17:29:57 Re: How does the tsearch configuration get selected?
Previous Message Simon Riggs 2007-06-16 16:46:12 Re: Load Distributed Checkpoints, revised patch

Browse pgsql-patches by date

  From Date Subject
Next Message Robert Treat 2007-06-16 20:56:58 Re: out of date url in developer faq
Previous Message Simon Riggs 2007-06-16 16:46:12 Re: Load Distributed Checkpoints, revised patch