Message-ID: <4814BDB8.2030108@agliodbs.com>
Date: Sun, 27 Apr 2008 10:54:00 -0700
From: Josh Berkus <josh@agliodbs.com>
User-Agent: Thunderbird 2.0.0.12 (Macintosh/20080213)
MIME-Version: 1.0
To: Gregory Stark <stark@enterprisedb.com>
CC: Euler Taveira de Oliveira <euler@timbira.com>,
	Greg Smith <gsmith@gregsmith.com>,
	postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: [pgsql-advocacy] Benchmarks WAS: Sun Talks about MySQL
References: <480F8C2D.6010806@emproshunts.com>
	<4811D1DD.9030401@otg-nc.com>	<20080425130105.GA19447@crankycanuck.ca>
	<36e682920804250741p33d621f3gf35e6bdebe2e0531@mail.gmail.com>
	<20080425152053.GE19447@crankycanuck.ca>
	<Pine.GSO.4.64.0804251942060.28069@westnet.com>
	<481278E7.9030504@timbira.com>
	<87wsmlm90e.fsf@oxford.xeocode.com>
In-Reply-To: <87wsmlm90e.fsf@oxford.xeocode.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

(thread crossed over to pgsql-performance, where it belongs, from 
pgsql-advocacy)

Greg,

> 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.
> 

You'd be surprised, then.  We're still horribly, horribly lock-bound on 
TPC-E; on anything over 4 cores lock resolution chokes us to death.  See 
Jignesh's and Paul's various posts about attempts to fix this.

Without resolving the locking issues, HOT and checkpoint doesn't have 
much effect on TPCE.

--Josh