Josh Berkus wrote: > Bruce, > > > We never actually considred undo, but high UPDATE activity was one of > > the areas we historically handled poorly compared to undo systems, and > > undo would have been one way to improve that area. I think with HOT we > > have improved high UPDATE activity enough that the undo benefits are no > > longer attractive (and of course the undo disadvantages were never > > attractive). > > > > If you're asking if we should remove the TODO (is there one?) and > replace it with a FAQ item called "Why PostgreSQL doesn't have an UNDO > LOG", then my vote is "yes".
No, it never got close to being a TODO item. It was more a limitation we had that is now fixed. -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match