Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()?

Поиск
Список
Период
Сортировка
Искать
От
Robert Haas
Тема
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()?
Дата
Msg-id
CA+TgmoaJ67VCefuhkd0fdJiWb64bqBtkbZazbVm6a0wimY0fRQ@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Andres Freund <andres@anarazel.de>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Robert Haas <robertmhaas@gmail.com>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Andres Freund <andres@anarazel.de>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Robert Haas <robertmhaas@gmail.com>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Tom Lane <tgl@sss.pgh.pa.us>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Andres Freund <andres@anarazel.de>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Andres Freund <andres@anarazel.de>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Andres Freund <andres@anarazel.de>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Tom Lane <tgl@sss.pgh.pa.us>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Andres Freund <andres@anarazel.de>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Andres Freund <andres@anarazel.de>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Andres Freund <andres@anarazel.de>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Tom Lane <tgl@sss.pgh.pa.us>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Andres Freund <andres@anarazel.de>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Andres Freund <andres@anarazel.de>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Andres Freund <andres@anarazel.de>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Tom Lane <tgl@sss.pgh.pa.us>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Andres Freund <andres@anarazel.de>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Andres Freund <andres@anarazel.de>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Andres Freund <andres@anarazel.de>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Andres Freund <andres@anarazel.de>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Amit Kapila <amit.kapila16@gmail.com>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Thomas Munro <thomas.munro@enterprisedb.com>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Andres Freund <andres@anarazel.de>
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Amit Kapila <amit.kapila16@gmail.com>
On Wed, Dec 19, 2018 at 5:37 PM Andres Freund  wrote:
> What's gained by the logic of emitting that warning in VACUUM after a
> crash? I don't really see any robustness advantages in it.  If the logic
> were that we'd never reuse empty pages because they can hide corruption
> that normally would discovered by checksums, then we shouldn't
> reinitialize them at all and instead error out hard - but we can't do
> that, because it's normal that they occur.  Right now we have empty
> pages on-disk whenever a busy server is restarted in immediate mode,
> after all.

I don't know.  I am just normally reluctant to change things
precipitously that are of long tenure.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

В списке pgsql-hackers по дате отправления
От: Chengchao Yu
Дата:
От: Tom Lane
Дата:
FAQ