diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/brin.out /tmp/cirrus-ci-build/contrib/pageinspect/results/brin.out --- /tmp/cirrus-ci-build/contrib/pageinspect/expected/brin.out 2024-10-25 07:03:29.639664821 +0000 +++ /tmp/cirrus-ci-build/contrib/pageinspect/results/brin.out 2024-10-25 07:07:33.377806351 +0000 @@ -161,50 +161,7 @@ SELECT * FROM brin_page_items(get_raw_page('brin_test_parallel_idx', 2), 'brin_test_parallel_idx') EXCEPT SELECT * FROM brin_page_items(get_raw_page('brin_test_serial_idx', 2), 'brin_test_serial_idx'); - itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty | value -------------+--------+--------+----------+----------+-------------+-------+------- -(0 rows) - -SELECT * FROM brin_page_items(get_raw_page('brin_test_serial_idx', 2), 'brin_test_serial_idx') -EXCEPT -SELECT * FROM brin_page_items(get_raw_page('brin_test_parallel_idx', 2), 'brin_test_parallel_idx'); - itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty | value -------------+--------+--------+----------+----------+-------------+-------+------- -(0 rows) - -DROP INDEX brin_test_parallel_idx; --- force parallel build, but don't allow starting parallel workers to force --- fallback to serial build, and repeat the checks -SET max_parallel_workers = 0; -CREATE INDEX brin_test_parallel_idx ON brin_parallel_test - USING brin (a int4_minmax_ops, a int4_bloom_ops, b, c int8_minmax_multi_ops) - WITH (pages_per_range=7) - WHERE NOT (a BETWEEN 1000 and 1500); -SELECT relname, relpages - FROM pg_class - WHERE relname IN ('brin_test_serial_idx', 'brin_test_parallel_idx') - ORDER BY relname; - relname | relpages -------------------------+---------- - brin_test_parallel_idx | 4 - brin_test_serial_idx | 4 -(2 rows) - -SELECT * FROM brin_page_items(get_raw_page('brin_test_parallel_idx', 2), 'brin_test_parallel_idx') -EXCEPT -SELECT * FROM brin_page_items(get_raw_page('brin_test_serial_idx', 2), 'brin_test_serial_idx'); - itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty | value -------------+--------+--------+----------+----------+-------------+-------+------- -(0 rows) - -SELECT * FROM brin_page_items(get_raw_page('brin_test_serial_idx', 2), 'brin_test_serial_idx') -EXCEPT -SELECT * FROM brin_page_items(get_raw_page('brin_test_parallel_idx', 2), 'brin_test_parallel_idx'); - itemoffset | blknum | attnum | allnulls | hasnulls | placeholder | empty | value -------------+--------+--------+----------+----------+-------------+-------+------- -(0 rows) - -DROP TABLE brin_parallel_test; -RESET min_parallel_table_scan_size; -RESET max_parallel_maintenance_workers; -RESET maintenance_work_mem; +server closed the connection unexpectedly + This probably means the server terminated abnormally + before or while processing the request. +connection to server was lost