Re: CREATE INDEX and HOT - revised design

Поиск

Список

Период

Сортировка

От	Pavan Deolasee
Тема	Re: CREATE INDEX and HOT - revised design
Дата	21 марта 2007 г. 14:00:16
Msg-id	2e78013d0703210959t5b0314cbk5d34738758c41911@mail.gmail.com обсуждение
Ответ на	Re: CREATE INDEX and HOT - revised design (Bruce Momjian <bruce@momjian.us>)
Ответы	Re: CREATE INDEX and HOT - revised design
Список	pgsql-hackers

Дерево обсуждения

On 3/21/07, Bruce Momjian <bruce@momjian.us> wrote:

I am worried that will require CREATE INDEX to wait for a long time.

Not unless there are long running transactions. We are not waiting
for the lock, but only for the current transactions to finish.

Is the pg_index xid idea too complex? It seems to give you the
per-tuple index bit, without the restrictions.

How do we handle HEAP_ONLY tuple cleanup ? If I understood
the proposal correctly, at the end of the create index, a HEAP_ONLY
tuple may have pointer from the new index, isn't it ?

Thanks,
Pavan

--

EnterpriseDB http://www.enterprisedb.com

В списке pgsql-hackers по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Re: CREATE INDEX and HOT - revised design