On Thu, Oct 02, 2003 at 10:09:12PM +0300, Hannu Krosing wrote:

> So what you really need is the CLUSTER command to leave pages half-empty
> and the tuple placement logic on inserts/updates to place new tuples
> near the place where they would be placed by CLUSTER. I.e. the code that
> does actual inserting should be aware of CLUSTERing.

Oh, you mean like what I half-proposed in

http://archives.postgresql.org/pgsql-general/2002-06/msg00968.php

BTW, this is the one message (the one on the CVS log I cite at the end)
that got me into Postgres hacking.  The little involvement I've had has
been great.  Thanks to all PostgreSQL hackers!

-- 
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"El realista sabe lo que quiere; el idealista quiere lo que sabe" (Anonimo)

In response to

• Re: Index/Function organized table layout at 2003-10-02 19:09:12 from Hannu Krosing

Responses

• Architecture Roadmap? at 2003-10-06 22:48:08 from James Rogers

pgsql-hackers by date

Next:	From: Database	Date: 2003-10-02 21:10:42
	Subject: US-CA DATABASE INTERNALS
Previous:	From: James Rogers	Date: 2003-10-02 20:44:51
	Subject: Re: Index/Function organized table layout