| From: | John Naylor <johncnaylorls(at)gmail(dot)com> |
|---|---|
| To: | jian he <jian(dot)universality(at)gmail(dot)com> |
| Cc: | Jeff Davis <pgsql(at)j-davis(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Gurjeet Singh <gurjeet(at)singh(dot)im>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Change GUC hashtable to use simplehash? |
| Date: | 2024-01-03 14:12:46 |
| Message-ID: | CANWCAZbm2tXPzDC8zOsREu9jQD2PbuGo-yyey_bY95QEQWo86w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Jan 2, 2024 at 6:56 AM jian he <jian(dot)universality(at)gmail(dot)com> wrote:
>
> My local computer is slow. but here is the test results:
>
> select * from bench_cstring_hash_aligned(100000); 7318.893 ms
> select * from bench_cstring_hash_unaligned(100000); 10383.173 ms
> select * from bench_pgstat_hash(100000); 4474.989 ms
> select * from bench_pgstat_hash_fh(100000); 9192.245 ms
> select * from bench_string_hash(100000); 2048.008 ms
This presents a 2x to 5x slowdown, so I'm skeptical this is typical --
what kind of platform is. For starters, what CPU and compiler?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Naylor | 2024-01-03 14:13:52 | Re: add AVX2 support to simd.h |
| Previous Message | John Naylor | 2024-01-03 14:10:11 | Re: [PoC] Improve dead tuple storage for lazy vacuum |