| From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
|---|---|
| To: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Teodor Sigaev <teodor(at)sigaev(dot)ru>, David Rowley <dgrowleyml(at)gmail(dot)com>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: hash_create API changes (was Re: speedup tidbitmap patch: hash BlockNumber) |
| Date: | 2014-12-24 09:32:16 |
| Message-ID: | 20141224093216.GJ23613@alap3.anarazel.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2014-12-24 00:27:39 -0600, Jim Nasby wrote:
> pgbench -S -T10 -c 4 -j 4
> master:
> tps = 9556.356145 (excluding connections establishing)
> tps = 9897.324917 (excluding connections establishing)
> tps = 9287.286907 (excluding connections establishing)
> tps = 10210.130833 (excluding connections establishing)
>
> XXH32:
> tps = 32462.754437 (excluding connections establishing)
> tps = 33232.144511 (excluding connections establishing)
> tps = 33082.436760 (excluding connections establishing)
> tps = 33597.904532 (excluding connections establishing)
FWIW, I don't believe these results for one second. It's quite plausible
that there's a noticeable performance benefit, but a factor of three is
completely unrealistic... Could you please recheck?
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dilip kumar | 2014-12-24 10:30:47 | Re: TODO : Allow parallel cores to be used by vacuumdb [ WIP ] |
| Previous Message | Andres Freund | 2014-12-24 09:30:19 | Re: Misaligned BufferDescriptors causing major performance problems on AMD |