Peter Eisentraut wrote:
> On a particular system, loading 1 million rows (100 bytes, nothing
> fancy) into PostgreSQL one transaction at a time takes about 90
> minutes. Doing the same in MySQL/InnoDB takes about 3 minutes. InnoDB
> is supposed to have a similar level of functionality as far as the
> storage manager is concerned, so I'm puzzled about how this can be.
> Does anyone know whether InnoDB is taking some kind of questionable
> shortcuts it doesn't tell me about?
MySQL/InnoDB offers the same knobs to force commits to disk as
PostgreSQL does. Look at innodb_flush_log_at_trx_commit and
innodb_flush_method:
http://dev.mysql.com/doc/mysql/en/innodb-start.html
Jochem