Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED
Date
Msg-id CAFcNs+oGfdLR4Fs2sAuqSbHadn7pLcPa_cFho4v1gcUprOqJqg@mail.gmail.com
Whole thread Raw
In response to Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
<div dir="ltr"><div class="gmail_extra"><br />On Mon, Jul 21, 2014 at 9:51 AM, Andres Freund <<a
href="mailto:andres@2ndquadrant.com">andres@2ndquadrant.com</a>>wrote:<br />><br />> On 2014-07-16 20:45:15
-0300,Fabrízio de Royes Mello wrote:<br /> > > > The rewrite will read in the 'old' contents - but because
it'sdone<br />> > > after the pg_class.relpersistence is changed they'll all not be marked<br />> > >
asBM_PERMANENT in memory. Then the ALTER TABLE is rolled back,<br /> > > > including the relpersistence
setting.Which will unfortunately leave<br />> > > pages with the wrong persistency setting in memory,
right?<br/>> > ><br />> ><br />> > That means should I "FlushRelationBuffers(rel)" before change
the<br/> > > relpersistence?<br />><br />> Did my explanation clarify the problem + possible solution
sufficiently?<br/>><br /><br />Yes, your explanation was enough. I didn't had time to working on it yet. But I hope 
workingon it today or tomorrow at least.<br /><br /></div><div class="gmail_extra">Regards,<br /><br /></div><div
class="gmail_extra">--<br/>Fabrízio de Royes Mello<br />Consultoria/Coaching PostgreSQL<br />>> Timbira: <a
href="http://www.timbira.com.br">http://www.timbira.com.br</a><br/> >> Blog sobre TI: <a
href="http://fabriziomello.blogspot.com">http://fabriziomello.blogspot.com</a><br/>>> Perfil Linkedin: <a
href="http://br.linkedin.com/in/fabriziomello">http://br.linkedin.com/in/fabriziomello</a><br/> >> Twitter: <a
href="http://twitter.com/fabriziomello">http://twitter.com/fabriziomello</a></div></div>

pgsql-hackers by date:

Previous
From: Thomas Fanghaenel
Date:
Subject: Re: Portability issues in TAP tests
Next
From: "Braunstein, Alan"
Date:
Subject: Exporting Table-Specified BLOBs Only?