[PATCH] [52] Review of patch 5381 - Documentation for pgstatindex fragmentation

2025-02-26 Thread ahmedashour
Hi all, I’m a beginner contributor reviewing patch 5381 from Commitfest 52. Here’s my feedback: - Applied the patch to the master branch (as of Feb 26, 2025) using `patch -p1 < 5381.patch`. - It updates doc/src/sgml/pgstattuple.sgml, adding a paragraph about `leaf_fragmentation`. - Built the HTML

[PATCH] Optimize SP-GiST text leaf comparisons with memcmp

2025-02-12 Thread ahmedashour
On Thr, Feb 13, 2025 at 3:03 AM, Ahmed Ashour <[a8087...@gmail.com]> wrote: > Hi PostgreSQL hackers, > > This patch optimizes text leaf comparisons in SP-GiST by replacing the manual > byte-by-byte comparison loop with `memcmp()`. The change improves performance > by leveraging highly optimized li