Re: "clearing" a relation file ! - Mailing list pgsql-admin

From David G. Johnston
Subject Re: "clearing" a relation file !
Date
Msg-id CAKFQuwYNSdvoa-Ygo2cL9QX4ZUGNQgB3xWj-Wrp_Q60tkFEoOw@mail.gmail.com
Whole thread Raw
In response to Re: "clearing" a relation file !  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: "clearing" a relation file !
Next
From: Thorsten Schöning
Date:
Subject: How to get a more RSYNC compatible output of pg_dump?