Re: "clearing" a relation file !

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: "clearing" a relation file !
Дата
Msg-id CAKFQuwYNSdvoa-Ygo2cL9QX4ZUGNQgB3xWj-Wrp_Q60tkFEoOw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: "clearing" a relation file !  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
On Sat, May 14, 2022 at 1:46 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Michel SALAIS" <msalais@msym.fr> writes:
> \! dd if=/dev/zero of=$file_path bs=1024 count=100

The other problem with this specific test is that an all-zero
page is considered to be a valid state.  You may consider that
a problem or not, but we're quite unlikely to change it, because
doing so would create false failure reports.  See the mechanisms
around file extension.


Should this detail be mentioned in the docs?


Namely (and not confirmed):

"A failure mode that produces empty pages will not be detected by this mechanism during normal server operation, but the pg_checksums application will since all normal usage of empty pages is restricted to runtime transient state."

David J.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: "clearing" a relation file !
Следующее
От: Thorsten Schöning
Дата:
Сообщение: How to get a more RSYNC compatible output of pg_dump?