Re: [HACKERS] Re: Bug#43221: postgresql: When disk is full, insert corrupts indices

Поиск
Список
Период
Сортировка
От Vadim Mikheev
Тема Re: [HACKERS] Re: Bug#43221: postgresql: When disk is full, insert corrupts indices
Дата
Msg-id 37C12CBA.3B7F0319@krs.ru
обсуждение исходный текст
Ответ на Re: [HACKERS] Re: Bug#43221: postgresql: When disk is full, insert corrupts indices  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> 
> Vadim Mikheev <vadim@krs.ru> writes:
> > Whenever index insert fails (for _any_ reason) index may be
>                                ^^^^^^^^^^^^^^^^
> > corrupted. I hope to address this with WAL...
> 
> One certainly hopes that's not true in the case of "cannot insert
> duplicate key into a unique index" failures !?

Oh, I meant cases when child btree page is splitted but
parent page is not updated, sorry.

BTW, duplicate check is made _before_ insertion...

Vadim
P.S. I'm on vacation till Aug 30...


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

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: [HACKERS] Tangent ... you know what's scary?
Следующее
От: Zakkr
Дата:
Сообщение: trigger: run in transaction