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

<div dir="ltr"><div class="gmail_extra"><br />On Mon, Mar 3, 2014 at 2:42 PM, Andres Freund <<a
href="mailto:andres@2ndquadrant.com">andres@2ndquadrant.com</a>>wrote:<br />><br />> On 2014-03-03 12:08:26
-0500,Stephen Frost wrote:<br /> > > * Robert Haas (<a
href="mailto:robertmhaas@gmail.com">robertmhaas@gmail.com</a>)wrote:<br />> > > On Mon, Mar 3, 2014 at 11:28
AM,Fabrízio de Royes Mello<br />> > > <<a
href="mailto:fabriziomello@gmail.com">fabriziomello@gmail.com</a>>wrote:<br /> > > > > Is the TODO item
"makean unlogged table logged" [1] a good GSoC project?<br />> > ><br />> > > I'm pretty sure we
foundsome problems in that design that we couldn't<br /> > > > figure out how to solve.  I don't have a
pointerto the relevant<br />> > > -hackers discussion off-hand, but I think there was one.<br />> ><br
/>>> ISTR the discussion going something along the lines of "we'd have to WAL<br /> > > log the entire
tableto do that, and if we have to do that, what's the<br />> > point?".<br />><br />> I don't see that as
aparticularly problematic problem. The primary<br />> reason to want to convert a unlogged to a logged table
probablyis that<br /> > it's easier to do so than to recreate the table + dependencies. Also the<br />> overhead
oflogging full pages will be noticeably smaller than the<br />> overhead of adding all rows individually, even if
using<br/> > heap_multi_insert().<br />><br /><br /></div><div class="gmail_extra">Do you know some similar in
thesource code?<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/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>