<html>
<head>
<meta http-equiv='Content-Type' content='text/html; charset=UTF-8'>
</head>
<body>
<style>
font{
line-height: 1.6;
}
ul,ol{
padding-left: 20px;
list-style-position: inside;
}
</style>
<div style = 'font-family:微软雅黑,Verdana,"Microsoft Yahei",SimSun,sans-serif; line-height:1.6;'>
<div ></div><div>
<div>Hello,</div><div><br></div><div>I'll take a look at some of the features that zheap undo, is considering for flashback based on undo.</div><div><br></div><div>Flashback Drop is more complex and, at the moment, doesn't do anything about it.</div>
<div>
<span>
<br>
</span>
</div>
<div style="font-family:'微软雅黑'">
<div style="font-size:14px; padding: 0; margin:0;">
<div style="padding-bottom:10px;margin-bottom:10px;display:inline-block;">
<div style="font-family:"微软雅黑"; font-size: 14px; color:#000000">
<style>
font{
line-height: 1.6;
}
</style>
Yang Jie<br><div>Highgo Software </div><div><a href="http://www.highgo.com/">http://www.highgo.com/</a></div><div><div><br></div></div>
</div>
</div>
</div>
</div>
</div><div class="J-reply" style="background-color:#f2f2f2;color:black;padding-top:6px;padding-bottom:6px;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;margin-top:45px;margin-bottom:20px;font-family:'微软雅黑';">
<div style="font-size:12px;line-height:1.5;word-break:break-all;margin-left:10px;margin-right:10px">On <span class="mail-date">10/18/2018 08:16</span>，<a class="mail-to" style="text-decoration:none;color:#2a83f2;" href="mailto:tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com">Tsunakawa, Takayuki<tsunakawa(dot)takay(at)jp(dot)fujitsu(dot)com></a> wrote： </div>
</div>
<blockquote id="ntes-pcmail-quote" style="margin: 0; padding: 0; font-size: 14px; font-family: '微软雅黑';">
From: Yang Jie [mailto:yangjie(at)highgo(dot)com]<br> <blockquote class="mmbqc1">Delayed cleanup, resulting in performance degradation, what are the<br> solutions recommended?<br> What do you suggest for the flashback feature?<br> Although postgres has excellent backup and restore capabilities, have you<br> considered adding flashbacks?<br></blockquote><br>Great proposal, I appreciate it.<br><br>Regarding the bloat, check the recent mail threads titled "undo xxx". A new table storage format is being developed to use undo logs like Oracle and MySQL instead of generating dead tuples.<br><br>How about the possibility of adding a feature like Flashback Drop to restore dropped and truncated tables? I sometimes saw customers who mistakenly dropped or truncated tables but didn't have any backup.<br><br><br>Regards<br>Takayuki Tsunakawa<br><br><br><br></blockquote><!--😀-->
</div>
</body>
</html>