Re: "clearing" a relation file !

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: "clearing" a relation file !
Дата
Msg-id 1019806.1652561174@sss.pgh.pa.us
обсуждение исходный текст
Ответ на "clearing" a relation file !  ("Michel SALAIS" <msalais@msym.fr>)
Ответы Re: "clearing" a relation file !  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Michel SALAIS"
Дата:
Сообщение: "clearing" a relation file !
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: "clearing" a relation file !