Re: CREATE INDEX and HOT - revised design

Поиск
Список
Период
Сортировка
От Pavan Deolasee
Тема Re: CREATE INDEX and HOT - revised design
Дата
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  (Bruce Momjian <bruce@momjian.us>)
Список 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 по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: CREATE INDEX and HOT - revised design
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: CREATE INDEX and HOT - revised design