X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 653E6D1DB5C for ; Wed, 21 Apr 2004 09:19:18 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 36767-05 for ; Wed, 21 Apr 2004 09:19:18 -0300 (ADT) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id CA260D1DB23 for ; Wed, 21 Apr 2004 09:19:14 -0300 (ADT) Received: from [134.22.70.203] (dyn-70-203.tor.dsl.tht.net [134.22.70.203]) by tht.net (Postfix) with ESMTP id DBA9376AC4; Wed, 21 Apr 2004 08:19:18 -0400 (EDT) Subject: Re: MySQL vs PG TPC-H benchmarks From: Rod Taylor To: Nick Barr Cc: PgSQL Performance ML In-Reply-To: <4086316B.4050304@chuckie.co.uk> References: <4086316B.4050304@chuckie.co.uk> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-3w/jNW2iPKXXKOlc+nq6" Message-Id: <1082549960.80320.108.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Wed, 21 Apr 2004 08:19:21 -0400 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/344 X-Sequence-Number: 6644 --=-3w/jNW2iPKXXKOlc+nq6 Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > I realize that MySQL & PG cannot really be compared (especially when you= =20 > consider the issues that MySQL has with things like data integrity) but= =20 > still surely PG would perform better than the stats show (i.e. #7 31.28= =20 > 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. --=20 Rod Taylor Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL PGP Key: http://www.rbt.ca/signature.asc --=-3w/jNW2iPKXXKOlc+nq6 Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (FreeBSD) iD8DBQBAhmbI6DETLow6vwwRAhRrAJ9/D8zePxGF2h84HiHyMaaf65/2LwCeInjq OJ+5gmGE3tuldo5Yg5U3hog= =79aK -----END PGP SIGNATURE----- --=-3w/jNW2iPKXXKOlc+nq6--