Do you use PostGIS BRIN?

[Tomas Vondra]

On 1/5/25 08:53, Regina Obe wrote:
> We are thinking of removing BRIN support in PostGIS because it has a serious
> bug as discussed here.
> 
> https://lists.osgeo.org/pipermail/postgis-devel/2025-January/030457.html
> 
> and here - https://trac.osgeo.org/postgis/ticket/5564
> 
> that currently causes crashes during Index building.
> 
> The two options on the table are:
> 
> 1) Fix the issue
> 2) Remove BRIN Support
> 
> 
> I'm leaning toward the removal of BRIN support because I see no point
> carrying the technical baggage of continuously supporting BRIN and testing
> it 
> if very very few people are using it.  Yes this will be a breaking change
> for those that use it.
> 

I'm not really involved in PostGIS and I'm not sure how widely used the
BRIN opclasses are, but I'd be willing to help with fixing/testing them.
I find BRIN indexes to be quite neat, it'd be somewhat sad if one of the
main projects built on Postgres ditched them.

I haven't tried but my impression is the fix wouldn't be that hard. Ofc,
that doesn't take away the long-term maintenance cost, but AFAIK this
shouldn't break very often either.


regards

-- 
Tomas Vondra