Re: Change GUC hashtable to use simplehash?
От | jian he |
---|---|
Тема | Re: Change GUC hashtable to use simplehash? |
Дата | |
Msg-id | CACJufxGy3JdpR8yo1ZzXjeLqQyV6+tSuom3zNjs-_6fnuxgBiQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Change GUC hashtable to use simplehash? (John Naylor <johncnaylorls@gmail.com>) |
Ответы |
Re: Change GUC hashtable to use simplehash?
(John Naylor <johncnaylorls@gmail.com>)
|
Список | pgsql-hackers |
On Wed, Jan 3, 2024 at 10:12 PM John Naylor <johncnaylorls@gmail.com> wrote: > > On Tue, Jan 2, 2024 at 6:56 AM jian he <jian.universality@gmail.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? I still cannot git apply your patch cleanly. in http://cfbot.cputube.org/ i cannot find your patch. ( so, it might be that I test based on incomplete information). but only hashfn_unstable.h influences bench_hash/bench_hash.c. so I attached the whole patch that I had git applied, that is the changes i applied for the following tests. how I test using pgbench: pgbench --no-vacuum --time=20 --file /home/jian/tmp/bench_cstring_hash_aligned.sql -M prepared | grep latency The following is tested with another machine, also listed machine spec below. I tested 3 times, the results is very similar as following: select * from bench_cstring_hash_aligned(100000); 4705.686 ms select * from bench_cstring_hash_unaligned(100000); 6835.753 ms select * from bench_pgstat_hash(100000); 2678.978 ms select * from bench_pgstat_hash_fh(100000); 6199.017 ms select * from bench_string_hash(100000); 847.699 ms src6=# select version(); version -------------------------------------------------------------------- PostgreSQL 17devel on x86_64-linux, compiled by gcc-11.4.0, 64-bit (1 row) jian@jian:~/Desktop/pg_src/src6/postgres$ gcc --version gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0 Copyright (C) 2021 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. lscpu: Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Address sizes: 46 bits physical, 48 bits virtual Byte Order: Little Endian CPU(s): 20 On-line CPU(s) list: 0-19 Vendor ID: GenuineIntel Model name: Intel(R) Core(TM) i5-14600K CPU family: 6 Model: 183 Thread(s) per core: 2 Core(s) per socket: 14 Socket(s): 1 Stepping: 1 CPU max MHz: 5300.0000 CPU min MHz: 800.0000 BogoMIPS: 6988.80 Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp l m constant_tsc art arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc cpuid aperfmperf tsc_known_freq pni pclmulqdq dtes64 monitor ds_cpl vm x smx est tm2 ssse3 sdbg fma cx16 xtpr pdcm sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm abm 3dnowprefetc h cpuid_fault ssbd ibrs ibpb stibp ibrs_enhanced tpr_shadow vnmi flexpriority ept vpid ept_ad fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid rdseed adx smap clflushopt clwb intel_pt sha_ni xsaveopt xsavec xgetbv1 xsaves split_lock_detect avx_vnni dtherm ida arat pln pts hwp hwp_notify hw p_act_window hwp_epp hwp_pkg_req hfi umip pku ospke waitpkg gfni vaes vpclmulqdq tme rdpid movdiri movdir64b fsrm md_clear serialize pconfig arch_l br ibt flush_l1d arch_capabilities Virtualization features: Virtualization: VT-x Caches (sum of all): L1d: 544 KiB (14 instances) L1i: 704 KiB (14 instances) L2: 20 MiB (8 instances) L3: 24 MiB (1 instance) NUMA: NUMA node(s): 1 NUMA node0 CPU(s): 0-19 Vulnerabilities: Gather data sampling: Not affected Itlb multihit: Not affected L1tf: Not affected Mds: Not affected Meltdown: Not affected Mmio stale data: Not affected Retbleed: Not affected Spec rstack overflow: Not affected Spec store bypass: Mitigation; Speculative Store Bypass disabled via prctl Spectre v1: Mitigation; usercopy/swapgs barriers and __user pointer sanitization Spectre v2: Mitigation; Enhanced IBRS, IBPB conditional, RSB filling, PBRSB-eIBRS SW sequence Srbds: Not affected Tsx async abort: Not affected jian@jian:~/Desktop/pg_src/src6/postgres$ git log commit bbbf8cd54a05ad5c92e79c96133f219e80fad77c (HEAD -> master) Author: jian he <jian.universality@gmail.com> Date: Thu Jan 4 10:32:39 2024 +0800 bench_hash contrib module commit c5385929593dd8499cfb5d85ac322e8ee1819fd4 Author: Peter Eisentraut <peter@eisentraut.org> Date: Fri Dec 29 18:01:53 2023 +0100 Make all Perl warnings fatal
Вложения
В списке pgsql-hackers по дате отправления: