Search Postgresql Archives

Re: How to Cluster an Index live?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Mike" <akiany@xxxxxxxxx> 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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux