Re: MySQL vs PG TPC-H benchmarks
Rod Taylor <pg@rbt.ca>
From: Rod Taylor <pg@rbt.ca>
To: Nick Barr <nicky@chuckie.co.uk>
Cc: PgSQL Performance ML <pgsql-performance@postgresql.org>
Date: 2004-04-21T12:22:29Z
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. OSDL not OSDN. > 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.