Re: unlogged tables
От
Jeff Janes
Тема
Re: unlogged tables
Дата
Msg-id
CAMkU=1wdMTE2w4iV2eLsA6rWXxzdkxFXE47ooGFE0-z1CjrY1g@mail.gmail.com
Ответ на
Re: unlogged tables (Yves Dorfsman)
Список
Дерево обсуждения
unlogged tables "Anibal David Acosta" <aa@devshock.com>
Re: unlogged tables dgabriel <gabriel.dodan@gmail.com>
Re: unlogged tables Matheus de Oliveira <matioli.matheus@gmail.com>
Re: unlogged tables dgabriel <gabriel.dodan@gmail.com>
Re: unlogged tables Yves Dorfsman <yves@zioup.com>
Re: unlogged tables Matheus de Oliveira <matioli.matheus@gmail.com>
Re: unlogged tables "David G. Johnston" <david.g.johnston@gmail.com>
Re: unlogged tables dgabriel <gabriel.dodan@gmail.com>
Re: unlogged tables Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: unlogged tables Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: unlogged tables Alvaro Herrera <alvherre@2ndquadrant.com>
Re: unlogged tables Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: unlogged tables Jeff Janes <jeff.janes@gmail.com>
Re: unlogged tables Yves Dorfsman <yves@zioup.com>
Re: unlogged tables Jeff Janes <jeff.janes@gmail.com>
Re: unlogged tables "David G. Johnston" <david.g.johnston@gmail.com>
Re: unlogged tables Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: unlogged tables "David G. Johnston" <david.g.johnston@gmail.com>
Re: unlogged tables Jeff Janes <jeff.janes@gmail.com>
Re: unlogged tables Stephen Frost <sfrost@snowman.net>
Re: unlogged tables Sergey Konoplev <gray.ru@gmail.com>
Re: unlogged tables Richard Huxton <dev@archonet.com>
Re: unlogged tables Sergey Konoplev <gray.ru@gmail.com>
Re: unlogged tables Richard Huxton <dev@archonet.com>
Re: unlogged tables Sergey Konoplev <gray.ru@gmail.com>
Re: unlogged tables "Anibal David Acosta" <aa@devshock.com>
Re: unlogged tables "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: unlogged tables "Anibal David Acosta" <aa@devshock.com>
Re: unlogged tables "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: unlogged tables Josh Berkus <josh@agliodbs.com>
Re: unlogged tables "Pierre C" <lists@peufeu.com>
On Tue, Apr 14, 2015 at 8:41 AM, Yves Dorfsman <yves@zioup.com> wrote:
On 2015-04-13 17:49, Jeff Janes wrote:
>
> One way would be to lock dirty buffers from unlogged relations into
> shared_buffers (which hardly seems like a good thing) until the start of a
> "super-checkpoint" and then write them all out as fast as possible (which kind
> of defeats checkpoint_completion_target). And then if the crash happened
> during a super-checkpoint, the data would still be inconsistent and need to be
> truncated.
>
What do you call a "super-checkpoint"?
A hypothetical checkpoint which includes writing and flushing pages of unlogged tables.
Presumably you wouldn't want every checkpoint to do this, because if done the way I described the super-checkpoint is a vulnerable period. Crashes that happen during it would result in truncation of the unlogged relation. Since that is the very thing we want to avoid, you would want to make these vulnerable periods rare.
Cheers,
Jeff
В списке pgsql-performance по дате отправления
