Re: How to Cluster an Index live?

"Mike" <akiany@gmail.com> writes:

> Look for it in 8.3:
> http://archives.postgresql.org/pgsql-patches/2006-08/msg00124.php

What he's looking for isn't actually included in that todo list. I'm sorry but
nobody has been looking at an online cluster command.

Clustered tables of the type you're imagining aren't really supported in
Postgres at all. What Postgres does is reorder the table in place but the
index is still stored separately. The patch you refer to here would help keep
the table in order as updates and inserts happen which doesn't currently
happen.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com