[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