Re: Known issue with Reindex-based corruption?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Known issue with Reindex-based corruption?
Дата
Msg-id 200402261003.00829.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Known issue with Reindex-based corruption?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Known issue with Reindex-based corruption?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Tom,

> That's a definite possibility.  Before 7.4 we did not emit WAL records
> for data written during index build.  What we could have here is that
> the transaction completed and synced to WAL, but none of the data-file
> writes were sent to disk before power-out.  On restart, WAL replay would
> faithfully update the pg_class row, but the index file would still be
> empty :-(

Would this be back-patchable by a good PG hacker?   The client has $$$.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Known issue with Reindex-based corruption?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Known issue with Reindex-based corruption?