Re: unlogged tables

From: Yves Dorfsman <yves(at)zioup(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: unlogged tables
Date: 2015-04-14 15:41:38
Message-ID: 552D3532.5020807@zioup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message dgabriel 2015-04-14 15:56:10 Re: unlogged tables
Previous Message David G. Johnston 2015-04-14 03:28:31 Re: unlogged tables