Thanks everyone for the analysis downthread. Here's a test case that
provokes the crash faster. Initialize with
create table brin_test (a text);
create index on brin_test using brin (a) with (pages_per_range = 1);
Then in one psql, run this:
select brin_summarize_new_values('brin_test_a_idx') \watch 0.1
and a pgbench running a script with this line (one client is enough):
insert into brin_test values (repeat(chr(ascii('A') + int4(random() * 61)),
int4(random() * 200)));
It crashes in 10-20 seconds for me.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
