GUC hashtable optimizations

Edit
Title GUC hashtable optimizations
Topic Performance
Created 2023-11-17 19:18:53
Last modified 2024-04-09 06:30:08 (3 weeks, 3 days ago)
Latest email 2024-04-07 01:40:15 (3 weeks, 5 days ago)
Status
2024-03: Committed
2024-01: Moved to next CF
Target version 17
Authors Jeff Davis (jdavis), John Naylor (john.naylor)
Reviewers Become reviewer
Committer John Naylor (john.naylor)
Links
Emails
Change GUC hashtable to use simplehash?
First at 2023-11-17 19:02:31 by Jeff Davis <pgsql at j-davis.com>
Latest at 2024-04-07 01:40:15 by John Naylor <johncnaylorls at gmail.com>
Latest attachment (v21-0001-Use-fasthash-for-string-keys-in-dynahash-and-dsh.patch) at 2024-04-07 01:40:15 from John Naylor <johncnaylorls at gmail.com>
    Attachment (v21-0001-Use-fasthash-for-string-keys-in-dynahash-and-dsh.patch) at 2024-04-07 01:40:15 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (v20-0002-Speed-up-tail-processing-when-hashing-aligned-C-.patch) at 2024-03-27 06:44:10 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Speed-up-tail-processing-when-hashing-aligned-C-.patch) at 2024-03-05 10:30:16 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Use-fasthash-for-dynahash-s-default-string-hash.patch) at 2024-02-06 07:59:52 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (v17-0002-Shorten-dependency-chain-for-computing-hash-mask.patch) at 2024-02-02 09:21:01 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (simd-hash-avx2-aesni.c) at 2024-01-30 12:51:24 from Ants Aasma <ants.aasma at cybertec.at> (Patch: No)
    Attachment (v16-0001-Speed-up-last-iteration-of-aligned-fasthash.patch) at 2024-01-30 10:04:20 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (0002-Unaligned-fasthash-word-at-a-time-hashing.patch) at 2024-01-29 21:12:55 from Ants Aasma <ants.aasma at cybertec.at> (Patch: Yes)
    Attachment (v15-0003-Use-fasthash-for-guc_name_hash.patch) at 2024-01-22 02:03:38 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (v14-0002-Add-optimized-C-string-hashing.patch) at 2024-01-17 07:15:11 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (v13-0005-WIP-a-safer-way-to-accumulate-a-single-struct-me.patch) at 2024-01-05 10:54:21 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (v12-0001-bench_hash-contrib-module.patch) at 2024-01-04 03:01:00 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v11-0005-Add-benchmark-for-hashing-C-strings.patch) at 2023-12-26 08:00:34 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (v11-0003-Use-fasthash32-for-pgstat_hash_hash_key.patch) at 2023-12-20 06:48:22 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (v10jd-0004-Optimize-hash-function-further.patch) at 2023-12-19 07:32:30 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v10-0003-Use-fasthash32-for-pgstat_hash_hash_key.patch) at 2023-12-18 06:39:02 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (fasthash32_nolen.txt) at 2023-12-15 01:20:12 from John Naylor <johncnaylorls at gmail.com> (Patch: No)
    Attachment (v8-0003-Add-bytewise-interface.patch) at 2023-12-10 14:57:04 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (v7-0011-Add-abiliy-to-case-fold-with-chunk-8-byte-interfa.patch) at 2023-12-10 06:26:31 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Use-new-hash-APIs-for-search-path-cache.patch) at 2023-12-09 19:18:15 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v6-0001-Vendor-fasthash.patch) at 2023-12-09 11:52:55 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (v5-0004-Add-bytewise-interface-for-incrementing-the-hash-.patch) at 2023-11-29 13:31:21 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Add-finalizer-to-guc_name_hash.patch) at 2023-11-22 13:06:34 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (0002-ADDENDUM-add-finalizer-to-guc-name-hash.patch.txt) at 2023-11-21 09:42:55 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (v3-0005-Use-SH_STORE_HASH-for-GUC-hash-table.patch) at 2023-11-19 22:54:41 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v2-0001-Convert-GUC-hashtable-to-use-simplehash.patch) at 2023-11-17 19:02:31 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
History
When Who What
2024-04-09 06:30:08 Andrey Borodin (x4m) Closed in commitfest 2024-03 with status: Committed
2024-04-09 06:30:08 Andrey Borodin (x4m) Changed committer to john.naylor
2024-03-08 09:25:14 John Naylor (john.naylor) New status: Waiting on Author
2024-02-01 17:53:46 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2024-01-24 01:43:28 John Naylor (john.naylor) New status: Needs review
2024-01-19 08:09:04 John Naylor (john.naylor) New status: Waiting on Author
2023-11-30 05:17:26 John Naylor (john.naylor) Changed authors to Jeff Davis (jdavis), John Naylor (john.naylor)
2023-11-19 22:17:18 Jeff Davis (jdavis) Changed topic to Performance
2023-11-19 22:17:18 Jeff Davis (jdavis) Changed name to GUC hashtable optimizations
2023-11-19 22:16:34 Jeff Davis (jdavis) New status: Needs review
2023-11-17 22:09:20 Jeff Davis (jdavis) Closed in commitfest 2024-01 with status: Withdrawn
2023-11-17 19:19:16 Jeff Davis (jdavis) Changed authors to Jeff Davis (jdavis)
2023-11-17 19:19:16 Jeff Davis (jdavis) Changed targetversion to 17
2023-11-17 19:19:16 Jeff Davis (jdavis) Changed name to Change GUC to use simplehash (tiny patch)
2023-11-17 19:18:53 Jeff Davis (jdavis) Attached mail thread d47ed659031babd416aaec45557e27e2a2e9ab70.camel@j-davis.com
2023-11-17 19:18:53 Jeff Davis (jdavis) Created patch record
Edit