(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
im****tant.
> 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
--
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
