Re: Still more REINDEX fun

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Still more REINDEX fun
Дата
Msg-id BANLkTi=FarX3XGke1tRg+yLfPd=PRtTyaA@mail.gmail.com
обсуждение исходный текст
Ответ на Still more REINDEX fun  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Still more REINDEX fun  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Wed, Apr 20, 2011 at 7:41 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> It's still true though that you have to be REINDEXing system catalogs to
> be at risk, else you shouldn't be seeing any IN_PROGRESS tuples.

So the fix seems to be that we make REINDEX on a system catalog lock
the whole catalog table.

Anything else seems likely to be heavily invasive, or at best
difficult to prove it is bug free.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Formatting Curmudgeons WAS: MMAP Buffers
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: pl/python tracebacks v2