| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Gregory Stark <stark(at)enterprisedb(dot)com> |
| Cc: | Euler Taveira de Oliveira <euler(at)timbira(dot)com>, Greg Smith <gsmith(at)gregsmith(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: [pgsql-advocacy] Benchmarks WAS: Sun Talks about MySQL |
| Date: | 2008-04-27 17:54:00 |
| Message-ID: | 4814BDB8.2030108@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-performance |
(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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrej Ricnik-Bay | 2008-04-27 18:39:16 | Re: New Zealanders? |
| Previous Message | Gregory Stark | 2008-04-26 06:21:21 | Re: Sun Talks about MySQL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Viktor Rosenfeld | 2008-04-27 19:02:19 | Re: Performance of the Materialize operator in a query plan |
| Previous Message | Greg Smith | 2008-04-27 13:01:46 | Re: Best practice to load a huge table from ORACLE to PG |