From: Yang Jie [mailto:yang...@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
