| 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 |
| 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 |