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

Re: Sun Talks about MySQL

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Euler Taveira de Oliveira" <euler(at)timbira(dot)com>
Cc: "Greg Smith" <gsmith(at)gregsmith(dot)com>, <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: Sun Talks about MySQL
Date: 2008-04-26 06:21:21
Message-ID: 87wsmlm90e.fsf@oxford.xeocode.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-performance
"Euler Taveira de Oliveira" <euler(at)timbira(dot)com> writes:

>> I recall Heikki was doing lots of tests with DBT2 for EnterpriseDB
>> comparing those two releases like that; anybody know of a good summary I
>> could utilize there? I thought that was one of the benchmarks that got a
>> 20-30% speedup on going to 8.3 because it really took advantage of HOT in
>> particular.

If you're doing large TPC-C runs then the phantom-command-id and packed
varlena changes give you about 9% space savings which translates surprisingly
nicely into about 9% TPM increase. (This is for a specific schema, if you
dumbify your schema with char(1)s and numerics you could see a bigger
difference)

HOT has a *huge* effect on how long your can run the benchmark before
performance starts to droop. However the minimum run time for TPCC is only 2
hours and for large runs that's not enough for vacuum-related issues to kick
in.

Also, smoothed checkpoints have a *huge* effect but TPC-C is based on 95th
percentile response times and the checkpoints only affect about 1% of the
transaction response times.

I think TPC-E will make both of these major improvements much more important.
I suspect it would be hard to get 8.2 to even pass TPC-E due to the checkpoint
dropouts.

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's On-Demand Production Tuning

In response to

Responses

pgsql-performance by date

Next:From: Robert TreatDate: 2008-04-26 13:10:53
Subject: Re: Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search
Previous:From: Euler Taveira de OliveiraDate: 2008-04-26 00:35:51
Subject: Re: Sun Talks about MySQL

pgsql-advocacy by date

Next:From: Josh BerkusDate: 2008-04-27 17:54:00
Subject: Re: [pgsql-advocacy] Benchmarks WAS: Sun Talks about MySQL
Previous:From: Euler Taveira de OliveiraDate: 2008-04-26 00:35:51
Subject: Re: Sun Talks about MySQL

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