Re: pgsql: Implement ALTER TABLE .. SET LOGGED / UNLOGGED

On August 23, 2014 3:49:32 PM CEST, Simon Riggs <simon(at)2ndQuadrant(dot)com> wrote:
>On 22 August 2014 19:30, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
>wrote:
>
>> Implement ALTER TABLE .. SET LOGGED / UNLOGGED
>>
>> This enables changing permanent (logged) tables to unlogged and
>> vice-versa.
>>
>> (Docs for ALTER TABLE / SET TABLESPACE got shuffled in an order that
>> hopefully makes more sense than the original.)
>
>When moving from unlogged to logged, where do we remove the init fork?
>
>Couldn't see the keywords fork or init anywhere in the patch, so maybe
>its hidden somewhere.

A new relfilenode is filled with the data - the old one, including the init fork, gets removed by the normal mechanics of rewriting rels.

---
Please excuse brevity and formatting - I am writing this on my mobile phone.