RE: Do you use PostGIS BRIN?

I did a quick Internet search which returned some discussion of the use of BRIN indexes and PostGIS. There appears, to me, that there are very limited ways to reach out and survey users of software in the World (esp FOSS). Good luck.

⁣39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia
(P) 03 62 396 397
(M) 0418 396 391
(W) www.spdba.com.au​

On 7 Jan 2025, 07:42, at 07:42, Regina Obe <[email protected]> wrote:
>Thanks for the input Arthur.
>
> 
>
>Much appreciated,
>
>Regina
>
> 
>
>From: Arthur Bazin <[email protected]> 
>Sent: Monday, January 6, 2025 3:16 PM
>To: Regina Obe <[email protected]>
>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 <[email protected]
><mailto:[email protected]> > 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