postgresql/contrib/pageinspect/sql
Tomas Vondra 0bd4b0689b Stabilize test of BRIN parallel create
As explained in 4d916dd876, the test instability is caused by delayed
cleanup of deleted rows. This commit removes the DELETE, stabilizing the
test without accidentally disabling parallel builds.

The intent of the delete however was to produce empty ranges, and test
that the parallel index build populates those correctly. But there's
another way to create empty ranges - partial indexes, which does not
rely on cleanup of deleted rows.

Idea to use partial indexes by Matthias van de Meent, patch by me.

Discussion: https://postgr.es/m/95d9cd43-5a92-407c-b7e4-54cd303630fe%40enterprisedb.com
2024-04-17 16:14:47 +02:00
..
brin.sql Stabilize test of BRIN parallel create 2024-04-17 16:14:47 +02:00
btree.sql Add bt_multi_page_stats() function to contrib/pageinspect. 2023-01-02 13:02:29 -05:00
checksum.sql Add an explicit test to catch changes in checksumming calculations. 2020-03-08 15:09:14 -04:00
gin.sql pageinspect: Fix handling of all-zero pages 2022-04-14 15:08:03 +09:00
gist.sql Introduce a new smgr bulk loading facility. 2024-02-23 16:10:51 +02:00
hash.sql pageinspect: Fix failure with hash_bitmap_info() for partitioned indexes 2023-12-19 18:19:05 +09:00
oldextversions.sql pageinspect: Improve page_header() for pages of 32kB 2021-07-12 11:05:27 +09:00
page.sql Prevent instability in contrib/pageinspect's regression test. 2022-11-21 10:50:50 -05:00