Skip site navigation (1) Skip section navigation (2)

Re: MySQL vs PG TPC-H benchmarks

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
Cc: Nick Barr <nicky(at)chuckie(dot)co(dot)uk>,"pgsql-performance (at) postgresql (dot) org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: MySQL vs PG TPC-H benchmarks
Date: 2004-04-21 18:57:16
Message-ID: 4086C40C.5020703@zeut.net (view raw or flat)
Thread:
Lists: 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.



In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2004-04-21 19:04:50
Subject: Re: Help understanding stat tables
Previous:From: Tom LaneDate: 2004-04-21 18:51:31
Subject: Re: Wierd context-switching issue on Xeon

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group