[PostGIS] #5564: BRIN indexes cause server crash after continuous autovacuum

[PostGIS]

#5564: BRIN indexes cause server crash after continuous autovacuum
----------------------+-----------------------------
  Reporter:  robe     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS Fund Me
 Component:  postgis  |    Version:  3.1.x
Resolution:           |   Keywords:
----------------------+-----------------------------
Comment (by robe):

 Tested

 {{{
 DROP TABLE IF EXISTS random_points;
 CREATE TABLE random_points AS
 SELECT ST_MakePoint(0, 0) AS geom FROM generate_series(1, 130_561);
 CREATE INDEX ON random_points USING brin(geom);
 }}}


 on:

  * PG13, 3.0.12dev
  * PG14 3.1.12, 3.6.0dev
  * PG15 3.5.0
  * PG16 3.5.0

 and doesn't crash on those, but 130_561 also gives a syntax error on
 PG13-PG15 above. So had to change that to 130561.  130561 crashes on 17
 3.5.0 too.

 We know this issue only triggers with parallelism enabled, e.g doing this:


 {{{
 SET max_parallel_workers TO 0;
 }}}

 will prevent it from crashing on PG17.  So I guess the trivial issue case
 only arises on PG17 and higher with parallelism enabled. I presuming
 because PG17 is the first version to support parallel builds of BRIN as
 noted in the feature matrix -
 https://www.postgresql.org/about/featurematrix/#indexing-constraints
 "Parallelized CREATE INDEX for BRIN indexes"
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5564#comment:9>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.