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

From Tom Lane
Subject Re: "clearing" a relation file !
Date
Msg-id 1019806.1652561174@sss.pgh.pa.us
Whole thread Raw
In response to "clearing" a relation file !  ("Michel SALAIS" <msalais@msym.fr>)
Responses Re: "clearing" a relation file !  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
"Michel SALAIS" <msalais@msym.fr> writes:
> \! dd if=/dev/zero of=$file_path bs=1024 count=100

This is fairly useless.

As you already noticed, it corrupts the on-disk data but has no
immediate effect on what's in shared buffers.  Depending on what
the timing of checkpoints is, the damage might even be self-healed
due to writing out shared buffers after you corrupt the storage.

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.

            regards, tom lane



pgsql-admin by date:

Previous
From: "Michel SALAIS"
Date:
Subject: "clearing" a relation file !
Next
From: "David G. Johnston"
Date:
Subject: Re: "clearing" a relation file !