| From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
|---|---|
| To: | "Mike" <akiany(at)gmail(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to Cluster an Index live? |
| Date: | 2007-07-16 15:39:04 |
| Message-ID: | 87fy3oe4tj.fsf@oxford.xeocode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Mike" <akiany(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Peterson | 2007-07-16 15:39:18 | Update of table lags execution of statement by >1 minute? |
| Previous Message | Bob Pawley | 2007-07-16 15:26:24 | Postgres Geometry |