Re: How to Cluster an Index live? - Mailing list pgsql-general

From Gregory Stark
Subject Re: How to Cluster an Index live?
Date
Msg-id 87fy3oe4tj.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: How to Cluster an Index live?  (Mike <akiany@gmail.com>)
List pgsql-general
"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


pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: encrypting a query string
Next
From: Richard Broersma Jr
Date:
Subject: Re: Postgres Geometry