Re: MySQL vs PG TPC-H benchmarks

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.