From: Rod Taylor <rbt@rbt.ca>
To: Nick Barr <nicky@chuckie.co.uk>
Cc: PgSQL Performance ML <pgsql-performance@postgresql.org>
Subject: Re: MySQL vs PG TPC-H benchmarks
Date: Wed, 21 Apr 2004 08:19:21 -0400
Message-ID: <1082549960.80320.108.camel@jester> (raw)
In-Reply-To: <4086316B.4050304@chuckie.co.uk>
References: <4086316B.4050304@chuckie.co.uk>
> 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.
--
Rod Taylor <rbt [at] rbt [dot] ca>
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
PGP Key: http://www.rbt.ca/signature.ascAttachments:
signature.asc (application/pgp-signature, 186B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rbt@rbt.ca, nicky@chuckie.co.uk
Subject: Re: MySQL vs PG TPC-H benchmarks
In-Reply-To: <1082549960.80320.108.camel@jester>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox