Re: Data corruption zero a file - help!!

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Data corruption zero a file - help!!
Дата
Msg-id 29260.1141952759@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Data corruption zero a file - help!!  (Noel Faux <noel.faux@med.monash.edu.au>)
Список pgsql-general
Noel Faux <noel.faux@med.monash.edu.au> writes:
> To clarify, when set on, every time it hits this error, postgres will
> rezero that block?

It'll only "re" zero if the page gets dropped from shared memory without
there having been any occasion to write it out.  Otherwise, the first
write will clobber the bad data on disk and that's the end of it.

My suggestion to use either VACUUM or SELECT COUNT(*) failed to take
that behavior into account --- VACUUM *will* rewrite the page, but a
SELECT scan won't dirty the page.  So you might consider a SELECT to see
how bad the situation is (how many bad pages) and then a VACUUM if you
want them cleaned up.

            regards, tom lane

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

Предыдущее
От: Jan de Visser
Дата:
Сообщение: Re: posgresql server connection
Следующее
От: Michael Louie Loria
Дата:
Сообщение: Run PostgreSQL with Administrator account in Windows