On 3/21/07, Bruce Momjian <[EMAIL PROTECTED]> 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

Reply via email to