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

PostGIS trac at osgeo.org
Thu Jan 2 15:32:41 PST 2025


#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):

 Not sure if this might be another way of crashing, easier to include if we
 ever decided to fix this issue.  This one reported by @velix on on
 postgis:osgeo.org matrix/IRC


 {{{
 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);
 }}}

 Takes a second to crash for me.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5564#comment:7>
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.


More information about the postgis-tickets mailing list