Postgres Pro
Downloads
Home   >   mailing lists

Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test? - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test?
Date
Msg-id 401EEEF0.8050001@familyhealth.com.au
Whole thread Raw
In response to Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test?  (Adam Ruth <aruth@intercation.com>)
Responses Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test?
Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test?
List pgsql-performance
Tree view 
> 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

pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Increasing number of PG connections.
Next
From: "scott.marlowe"
Date:
Subject: Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test?