(thread crossed over to pgsql-performance, where it belongs, from
> 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
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.
In response to
pgsql-performance by date
|Next:||From: Viktor Rosenfeld||Date: 2008-04-27 19:02:19|
|Subject: Re: Performance of the Materialize operator in a query plan|
|Previous:||From: Greg Smith||Date: 2008-04-27 13:01:46|
|Subject: Re: Best practice to load a huge table from ORACLE to PG|
pgsql-advocacy by date
|Next:||From: Andrej Ricnik-Bay||Date: 2008-04-27 18:39:16|
|Subject: Re: New Zealanders?|
|Previous:||From: Gregory Stark||Date: 2008-04-26 06:21:21|
|Subject: Re: Sun Talks about MySQL|