| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Michel SALAIS" <msalais(at)msym(dot)fr> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: "clearing" a relation file ! |
| Date: | 2022-05-14 20:46:14 |
| Message-ID: | 1019806.1652561174@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Michel SALAIS" <msalais(at)msym(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2022-05-14 21:06:56 | Re: "clearing" a relation file ! |
| Previous Message | Michel SALAIS | 2022-05-14 20:15:37 | "clearing" a relation file ! |