Re: BUG #5599: Vacuum fails due to index corruption issues

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #5599: Vacuum fails due to index corruption issues
Дата
Msg-id 16374.1281026184@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #5599: Vacuum fails due to index corruption issues  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: BUG #5599: Vacuum fails due to index corruption issues  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-bugs
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Excerpts from Tom Lane's message of jue ago 05 11:06:57 -0400 2010:
>> 1. Write the dirty buffers before dropping them.  Kind of ugly from a
>> performance viewpoint, but simple and safe.

> I think "simple" is good, considering that this code is gone in 9.0 and
> HEAD.  IMHO investing too much effort on this problem is not worth it.

Gone?  Looks like it's still there to me.

> Perhaps it'd be good to come up with a better solution for HEAD:

Yeah, the panic-on-replay aspect is troublesome.  I feel like we need a
rethink here.  But I agree that solution #1 is the only one that feels
safe enough for backpatching.

            regards, tom lane

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #5599: Vacuum fails due to index corruption issues
Следующее
От: "Chris"
Дата:
Сообщение: BUG #5602: Recovering from Hot-Standby file backup leads to the currupted indexes