GUC hashtable optimizations

Edit
Title GUC hashtable optimizations
Topic Performance
Created 2023-11-17 19:18:53
Last modified 2024-02-01 17:53:46 (4 weeks ago)
Latest email 2024-02-08 03:11:53 (3 weeks, 1 day ago)
Status
2024-03: Needs review
2024-01: Moved to next CF
Target version 17
Authors Jeff Davis (jdavis), John Naylor (john.naylor)
Reviewers Become reviewer
Committer
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-02-08 03:11:53 by John Naylor <johncnaylorls at gmail.com>
Latest 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>
    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-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