BRIN index WAL is broken in HEAD.

Commit 2c03216d831160bedd72d4, the Revamp the WAL record format, is the
culprit.

The easiest way to see this is via streaming replication.

On master:

create table foobar as select * from generate_series(1,10000);
create index on foobar using brin (generate_series );

On replica:

set enable_seqscan TO off;
explain (analyze) select count(*) from foobar ;
ERROR:  corrupted BRIN index: inconsistent range map

Cheers,

Jeff

Reply via email to