Paul Thomas wrote:
> Looks like he's using the default postgresql.conf settings in which
> case I'm not suprised at pg looking so slow. His stated use of foreign
> keys invalidates the tests anyway as MyISAM tables don't support FKs
> so we're probably seeing FK check overheads in pg that are simply
> ignore by MySQL. In an honest test, MySQL should be reported as
> failing those tests.
Either failures, or they should not have been using MyISAM, they should
have used the table format that supports FK's. This is just not apples
to apples.