Thanks for the input Arthur.
Much appreciated,
Regina
From: Arthur Bazin <arthurba...@gmail.com>
Sent: Monday, January 6, 2025 3:16 PM
To: Regina Obe <l...@pcorp.us>
Subject: Re: Do you use PostGIS BRIN?
Hi,
Always have used GiST index, never BRIN.
I do a lots of DB audit for many clients and I have never seen any use of BRIN
index.
I think that this is not really used and maybe only by specific users with
specific needs (for speed and space maybe).
Best regards !
Arthur Bazin
We are all made of star stuff - Carl Sagan
Pensez à la planète, merci de n'imprimer ce mail que si cela est vraiment
nécessaire
Le dim. 5 janv. 2025 à 10:06, Regina Obe <l...@pcorp.us <mailto:l...@pcorp.us>
> a écrit :
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.
Thanks,
Regina
