Do you use PostGIS BRIN?

[Regina Obe]

Thanks for the input Arthur.

 

Much appreciated,

Regina

 

From: Arthur Bazin <arthurbazin at gmail.com> 
Sent: Monday, January 6, 2025 3:16 PM
To: Regina Obe <lr at 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 <lr at pcorp.us <mailto:lr at 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20250106/16659824/attachment.htm>