Re: MySQL vs PG TPC-H benchmarks - Mailing list pgsql-performance

From Matthew T. O'Connor
Subject Re: MySQL vs PG TPC-H benchmarks
Date
Msg-id 4086C40C.5020703@zeut.net
Whole thread Raw
In response to Re: MySQL vs PG TPC-H benchmarks  (Paul Thomas <paul@tmsl.demon.co.uk>)
List pgsql-performance
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.



pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Wierd context-switching issue on Xeon
Next
From: Tom Lane
Date:
Subject: Re: Help understanding stat tables