Re: GSoC proposal - "make an unlogged table logged"

<div dir="ltr"><div class="gmail_extra"><br />On Thu, Mar 6, 2014 at 5:05 PM, Fabrízio de Royes Mello <<a
href="mailto:fabriziomello@gmail.com">fabriziomello@gmail.com</a>>wrote:<br />><br />><br />> On Thu, Mar
6,2014 at 5:04 PM, Robert Haas <<a href="mailto:robertmhaas@gmail.com">robertmhaas@gmail.com</a>> wrote:<br />
>><br />> > On Thu, Mar 6, 2014 at 2:52 PM, Fabrízio de Royes Mello<br />> > <<a
href="mailto:fabriziomello@gmail.com">fabriziomello@gmail.com</a>>wrote:<br />> > > On Thu, Mar 6, 2014 at
4:42PM, Robert Haas <<a href="mailto:robertmhaas@gmail.com">robertmhaas@gmail.com</a>> wrote:<br /> > >
>>I think this isn't a good design.  Per the discussion between Andres<br />> > >> and I, I think
thatI think you should do is make ALTER TABLE .. SET<br />> > >> LOGGED work just like VACUUM FULL, with
theexception that it will set<br /> > > >> a different relpersistence for the new relfilenode.  If you do
itthat<br />> > >> way, this will be less efficient, but much simpler, and you might<br />> >
>>actually finish it in one summer.<br /> > > >><br />> > ><br />> > > Do it like
'VACUUMFULL' for any wal_level?<br />> ><br />> > Yep.  Anything else appears to be a research problem.<br
/>>><br />><br />> I'll change the proposal. Thanks a lot!<br /> ><br /><br /></div><div
class="gmail_extra">Onelast question. <br /><br />Do you think is difficult to implement "ALTER TABLE ... SET UNLOGGED"
too?Thinking in a scope of one GSoC, of course.<br /></div><div class="gmail_extra"><br /></div><div
class="gmail_extra">Regards,<br/></div><div class="gmail_extra"><br />--<br />Fabrízio de Royes Mello<br
/>Consultoria/CoachingPostgreSQL<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>