Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED
От | Fabrízio de Royes Mello |
---|---|
Тема | Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED |
Дата | |
Msg-id | CAFcNs+oGfdLR4Fs2sAuqSbHadn7pLcPa_cFho4v1gcUprOqJqg@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED (Andres Freund <andres@2ndquadrant.com>) |
Список | 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 по дате отправления: