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

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: pgsql: Implement ALTER TABLE .. SET LOGGED / UNLOGGED
Дата
Msg-id ed855a59-8527-4144-bf68-d01b4483c1d3@email.android.com
обсуждение исходный текст
Ответ на Re: pgsql: Implement ALTER TABLE .. SET LOGGED / UNLOGGED  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: pgsql: Implement ALTER TABLE .. SET LOGGED / UNLOGGED  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-committers
On August 23, 2014 3:49:32 PM CEST, Simon Riggs <simon@2ndQuadrant.com> wrote:
>On 22 August 2014 19:30, Alvaro Herrera <alvherre@alvh.no-ip.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
ofrewriting rels. 

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


В списке pgsql-committers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: pgsql: Implement ALTER TABLE .. SET LOGGED / UNLOGGED
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: pgsql: Implement ALTER TABLE .. SET LOGGED / UNLOGGED