-- for the different opclasses we build later).

INSERT INTO brin_parallel_test

SELECT (CASE WHEN (mod(i,231) = 0) OR (i BETWEEN 3500 AND 4000) THEN NULL ELSE i END),

(CASE WHEN (mod(i,233) = 0) OR (i BETWEEN 3750 AND 4250) THEN NULL ELSEmd5(i::text) END),

(CASE WHEN (mod(i,233) = 0) OR (i BETWEEN 3750 AND 4250) THEN NULL ELSEencode(sha256(i::text::bytea), 'hex') END),

(CASE WHEN (mod(i,233) = 0) OR (i BETWEEN 3850 AND 4500) THEN NULL ELSE (i/100) + mod(i,8) END)

FROM generate_series(1,5000) S(i);

-- Build an index with different opclasses - minmax, bloom and minmax-multi.

ORDER BY relname;

relname | relpages

------------------------+----------

brin_test_parallel_idx |3

brin_test_serial_idx |3

brin_test_parallel_idx |4

brin_test_serial_idx |4

(2 rows)

-- Check that (A except B) and (B except A) is empty, which means the indexes

ORDER BY relname;

relname | relpages

------------------------+----------

brin_test_parallel_idx |3

brin_test_serial_idx |3

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

INSERT INTO brin_parallel_test

SELECT (CASE WHEN (mod(i,231)=0)OR (i BETWEEN3500AND4000) THENNULL ELSE i END),

(CASE WHEN (mod(i,233)=0)OR (i BETWEEN3750AND4250) THENNULL ELSEmd5(i::text) END),

(CASE WHEN (mod(i,233)=0)OR (i BETWEEN3750AND4250) THENNULL ELSEencode(sha256(i::text::bytea),'hex') END),

(CASE WHEN (mod(i,233)=0)OR (i BETWEEN3850AND4500) THENNULL ELSE (i/100)+ mod(i,8) END)

FROM generate_series(1,5000) S(i);