Hello,

I'll take a look at some of the features that zheap undo, is considering for flashback based on undo.

Flashback Drop is more complex and, at the moment, doesn't do anything about it.
Yang Jie
Highgo Software 

On 10/18/2018 08:16，Tsunakawa, Takayuki<tsunakawa.takay@jp.fujitsu.com> wrote：
From: Yang Jie [mailto:yangjie@highgo.com]
Delayed cleanup, resulting in performance degradation, what are the
solutions recommended?
What do you suggest for the flashback feature?
Although postgres has excellent backup and restore capabilities, have you
considered adding flashbacks?

Great proposal, I appreciate it.

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.

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.


Regards
Takayuki Tsunakawa