Re: Detecting corrupted pages earlier

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Detecting corrupted pages earlier
Дата
Msg-id 8887.1045634946@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Detecting corrupted pages earlier  (Hiroshi Inoue <Inoue@tpf.co.jp>)
Список pgsql-hackers
Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> Tom Lane wrote:
>> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
>>> Is there a way to make our way around the pages ?
>> 
>> If the header is corrupt, I don't think so.

> What I asked is how to read all other sane pages.

Oh, I see.  You can do "SELECT ... LIMIT n" to get the rows before the
broken page, but there's no way to get the ones after it.  My proposal
won't make this worse, but it won't make it any better either.  Do you
have an idea how to get the rows after the broken page?
        regards, tom lane


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

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Detecting corrupted pages earlier
Следующее
От: Dennis Björklund
Дата:
Сообщение: translation stats