On Tue, Jan 2, 2024 at 6:56 AM jian he <jian.universal...@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?