Re: BUG #10675: alter database set tablespace and unlogged table - Mailing list pgsql-bugs

From Fujii Masao
Subject Re: BUG #10675: alter database set tablespace and unlogged table
Date
Msg-id CAHGQGwEJt7HDAAD2y4KD=iXYmtNpxLXKUgaAekGXcL9GVbCGgQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #10675: alter database set tablespace and unlogged table  (Pavan Deolasee <pavan.deolasee@gmail.com>)
List pgsql-bugs
On Fri, Aug 8, 2014 at 4:08 PM, Pavan Deolasee <pavan.deolasee@gmail.com> wrote:
> On Thu, Aug 7, 2014 at 5:54 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
>>
>>
>>
>> What's the status of this?
>
>
> There was no clear consensus. The thread has patches per both the
> approaches. I tried to bring it up couple of times, last time just before
> the minor releases were out. But did not get any attention.

I vote to make checkpoint flush unlogged tables only when the special flag
(that maybe we will introduce) is set. Unlogged tables are not flushed by
manual checkpoint. Per Robert, that's originally intentional. No dangerous
risk that may cause has been reported yet. So I don't think that we need to
change manual checkpoint so that it always flushes unlogged tables, at least
for now.

OTOH, I agree to extend manual checkpoint so that it can flush unlogged
table to shorten the time of subsequent shutdown checkpoint. For example,
we can implement something like "CHECKPOINT [ALL | PERMANENT | UNLOGGED]".
But that's a feature request. We should work on this later, not for now.

>> ISTM that the patch has not been applied yet. Right?
>>
>
> Right. I've now added it to the commitfest so that we don't lose track of
> it.

Thanks!

Regards,

--
Fujii Masao

pgsql-bugs by date:

Previous
From: Sandeep Thakkar
Date:
Subject: Re: Re: BUG #11039: installation fails when trying to install C++ redistributable
Next
From: pjduplooy
Date:
Subject: Re: BUG #11039: installation fails when trying to install C++ redistributable