Re: unlogged tables - Mailing list pgsql-performance

From Yves Dorfsman
Subject Re: unlogged tables
Date
Msg-id 552D3532.5020807@zioup.com
Whole thread Raw
In response to Re: unlogged tables  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: unlogged tables  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-performance
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"?

--
http://yves.zioup.com
gpg: 4096R/32B0F416



pgsql-performance by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: unlogged tables
Next
From: dgabriel
Date:
Subject: Re: unlogged tables