Re: [PERFORM] [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test?

[Adam Ruth]

Wow, I didn't know that (didn't get far enough to test any rollback).  
That's not a good thing.  <facetious>But then again, it's MySQL who 
needs rollback anyway?</facetious>

On Feb 2, 2004, at 5:44 PM, Christopher Kings-Lynne wrote:

One more thing that annoyed me.  If you started a process, such as a 
large DDL operation, or heaven forbid, a cartesian join (what?  I 
never do that!).
I believe InnoDB also has O(n) rollback time.  eg. if you are rolling 
back 100 million row changes, it takes a long, long time.  In 
PostgreSQL rolling back is O(1)...

Chris



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster