Re: MySQL+InnoDB vs. PostgreSQL test?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Adam Ruth <aruth(at)intercation(dot)com>
Cc: josh(at)agliodbs(dot)com, pgsql-advocacy(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: MySQL+InnoDB vs. PostgreSQL test?
Date: 2004-02-03 00:44:32
Message-ID: 401EEEF0.8050001@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-performance

> 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

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message scott.marlowe 2004-02-03 01:18:32 Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
Previous Message Robert Treat 2004-02-02 20:14:08 Re: MySQL+InnoDB vs. PostgreSQL test?

Browse pgsql-performance by date

  From Date Subject
Next Message Slavisa Garic 2004-02-03 00:55:31 COPY from question
Previous Message scott.marlowe 2004-02-02 23:45:42 Re: Increasing number of PG connections.