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
Ответ на
Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? (Andres Freund)
Список
Дерево обсуждения
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
Дата: