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

Re: MySQL vs PG TPC-H benchmarks

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Nick Barr <nicky(at)chuckie(dot)co(dot)uk>
Cc: PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: Re: MySQL vs PG TPC-H benchmarks
Date: 2004-04-21 12:22:29
Message-ID: 1082550148.80320.111.camel@jester (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
On Wed, 2004-04-21 at 08:19, Rod Taylor wrote:
> > I realize that MySQL & PG cannot really be compared (especially when you 
> > consider the issues that MySQL has with things like data integrity) but 
> > still surely PG would perform better than the stats show (i.e. #7 31.28 
> > seconds versus 42 minutes!!!).
> We know that PostgreSQL 7.5 will perform much better than 7.4 did due to
> the efforts of OSDN and Tom.


> I've enquired as to whether they ran ANALYZE after the data load. They
> don't explicitly mention it, and given the mention it took 2.5days to
> load 1GB of data, they're not regular PostgreSQL users.

In response to

pgsql-performance by date

Next:From: Paul ThomasDate: 2004-04-21 12:55:21
Subject: Re: MySQL vs PG TPC-H benchmarks
Previous:From: Rod TaylorDate: 2004-04-21 12:19:21
Subject: Re: MySQL vs PG TPC-H benchmarks

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