Re: Block B-Tree concept

Поиск
Список
Период
Сортировка
От Csaba Nagy
Тема Re: Block B-Tree concept
Дата
Msg-id 1159368006.3874.171.camel@coppola.muc.ecircle.de
обсуждение исходный текст
Ответ на Re: Block B-Tree concept  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Block B-Tree concept  (Gregory Stark <gsstark@mit.edu>)
Список pgsql-hackers
> > I think you build a whole new index named something like ".temp-reindex" and
> > then as the last step of the second transaction delete the old idnex and
> > rename the new index.
> 
> That would require getting exclusive lock on the table.

Just out of curiosity, creating a new index concurrently (or online,
whatever you call it) doesn't require to set an exclusive lock on the
table ? I thought it would, at least swiftly at the end of the
operation, after all it's modifying the table...

Cheers,
Csaba.




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: psql service parameter
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: psql service parameter