| From: | Junwang Zhao <zhjwpku(at)gmail(dot)com> |
|---|---|
| To: | John Naylor <johncnaylorls(at)gmail(dot)com> |
| Cc: | jian he <jian(dot)universality(at)gmail(dot)com>, 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-08 07:24:40 |
| Message-ID: | CAEG8a3KnwqopxjHSm0rVy4jBKhOw7_25VWp0Gq6FDSdiqKOb=g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi John,
On Mon, Jan 8, 2024 at 10:44 AM John Naylor <johncnaylorls(at)gmail(dot)com> wrote:
>
> On Sat, Jan 6, 2024 at 9:01 AM jian he <jian(dot)universality(at)gmail(dot)com> wrote:
> >
> > latency average = 147.782 ms
> > select * from bench_cstring_hash_unaligned(100000);
> > latency average = 101.179 ms
> > select * from bench_cstring_hash_aligned(100000);
> > latency average = 101.219 ms
>
> Thanks for testing again! This looks closer to my results. It doesn't
> show improvement for the aligned case, but it's not worse, either.
>
> There is still some polishing to be done, mostly on comments/examples,
> but I think it's mostly there. I'll return to it by next week.
>
>
+ * Portions Copyright (c) 2018-2023, PostgreSQL Global Development Group
A kind reminder, it's already 2024 :)
I'm also curious why the 2018, is there any convention for that?
--
Regards
Junwang Zhao
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2024-01-08 07:27:57 | Escape output of pg_amcheck test |
| Previous Message | Bharath Rupireddy | 2024-01-08 07:21:56 | Re: Documentation to upgrade logical replication cluster |