| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-04-21 19:04:50 | Re: Help understanding stat tables |
| Previous Message | Tom Lane | 2004-04-21 18:51:31 | Re: Wierd context-switching issue on Xeon |