Re: Support for REINDEX CONCURRENTLY

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Support for REINDEX CONCURRENTLY
Дата
Msg-id 13502.1349319089@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Support for REINDEX CONCURRENTLY  (Greg Stark <stark@mit.edu>)
Ответы Re: Support for REINDEX CONCURRENTLY
Re: Support for REINDEX CONCURRENTLY
Список pgsql-hackers
Greg Stark <stark@mit.edu> writes:
> I'm a bit puzzled why we're so afraid of swapping the relfilenodes
> when that's what the current REINDEX does.

Swapping the relfilenodes is fine *as long as you have exclusive lock*.
The trick is to make it safe without that.  It will definitely not work
to do that without exclusive lock, because at the instant you would try
it, people will be accessing the new index (by OID).
        regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Make CREATE AGGREGATE check validity of initcond value?
Следующее
От: Craig Ringer
Дата:
Сообщение: Docs bug: SET ROLE docs should "see also: DISCARD ALL"