[PATCH] add missed tests for gist index

From: shihao zhong <zhong950419(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: [PATCH] add missed tests for gist index
Date: 2026-09-05 02:16:38
Message-ID: CAGRkXqTSFafbY-jKGapxguEiRM8ywo8naSU5ZTdbO6J3A2d37g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers,

Two test-only patches.

gist.sql vacuums only once after deleting rows, so the emptied leaf pages
are never recycled or reused, and no test deletes every entry. Nothing
replays a GiST page deletion through recovery either.

0001 adds those steps to gist.sql. 0002 adds a recovery test that crashes
and restarts the server after the same workload, with
wal_consistency_checking set. Both compare an index scan against a
sequential scan.

Coverage of src/backend/access/gist goes from 80.3% to 87.9%; the redo side
of gistxlog.c was entirely unexecuted before.

Thanks,
Shihao

Attachment Content-Type Size
llvm-cov-raw.txt text/plain 2.0 KB
0001-Test-GiST-page-recycling-and-deleting-all-entries.patch application/octet-stream 4.6 KB
0002-Add-a-recovery-test-for-GiST-page-deletion-and-reuse.patch application/octet-stream 4.6 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message shihao zhong 2026-09-05 02:52:16 Re: Collect ALTER PUBLICATION commands for event triggers
Previous Message shihao zhong 2026-09-05 02:04:08 Re: Lazy snapshot distribution in logical decoding