Re: How to Cluster an Index live?

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: How to Cluster an Index live?
Дата
Msg-id 87fy3oe4tj.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: How to Cluster an Index live?  (Mike <akiany@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tino Wildenhain
Дата:
Сообщение: Re: encrypting a query string
Следующее
От: Richard Broersma Jr
Дата:
Сообщение: Re: Postgres Geometry