<html v="urn:schemas-microsoft-com:vml" o="urn:schemas-microsoft-com:office:office" w="urn:schemas-microsoft-com:office:word" m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Aptos;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:12.0pt;
font-family:"Aptos",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:11.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang="EN-US" link="blue" vlink="purple" style="overflow-wrap: break-word; zoom: 0%;"><div dir="auto">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.<br><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->39 Cliff View Drive, Allens Rivulet, 7150, Tasmania, Australia<!-- tmjah_g_1299e --><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->(P) 03 62 396 397<!-- tmjah_g_1299e --><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->(M) 0418 396 391<!-- tmjah_g_1299e --><br></div>
<div dir="auto"><!-- tmjah_g_1299s -->(W) <!-- tmjah_g_1299e --><a href="http://www.spdba.com.au"><!-- tmjah_g_1299s --><a href="http://www.spdba.com.au">www.spdba.com.au</a><!-- tmjah_g_1299e --></a></div>
<div class="gmail_quote" >On 7 Jan 2025, at 07:42, Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="WordSection1"><p class="MsoNormal"><span style="font-size:11.0pt">Thanks for the input Arthur.</span></p><p></p><p></p><p class="MsoNormal"><span style="font-size:11.0pt"></span></p><p> </p><p></p><p class="MsoNormal"><span style="font-size:11.0pt">Much appreciated,</span></p><p></p><p></p><p class="MsoNormal"><span style="font-size:11.0pt">Regina</span></p><p></p><p></p><p class="MsoNormal"><span style="font-size:11.0pt"></span></p><p> </p><p></p><div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt"><div><div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in"><p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Arthur Bazin <arthurbazin@gmail.com> <br><b>Sent:</b> Monday, January 6, 2025 3:16 PM<br><b>To:</b> Regina Obe <lr@pcorp.us><br><b>Subject:</b> Re: Do you use PostGIS BRIN?</span></p><p></p><p></p></div></div><p class="MsoNormal"></p><p> </p><div><div><div><div><p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif">Hi,</span></p><p></p><p></p></div><div><p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif"></span></p><p> </p><p></p></div><div><p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif">Always have used GiST index, never BRIN. </span></p><p></p><p></p></div><div><p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif">I do a lots of DB audit for many clients and I have never seen any use of BRIN index.</span></p><p></p><p></p></div><div><p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif">I think that this is not really used and maybe only by specific users with specific needs (for speed and space maybe).</span></p><p></p><p></p><div><p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif"><br clear="all"></span></p><p></p><p></p></div><div><div><div><div><div><p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif">Best regards ! </span></p><p></p><p></p><table class="MsoNormalTable" border="1" cellpadding="0" style="border:solid #EEEDED 1.0pt;border-spacing:0px"><tbody><tr style="height:11.25pt"><td colspan="3" style="border:none;padding:.75pt .75pt .75pt .75pt;height:11.25pt"></td></tr><tr style="height:37.5pt"><td width="220" style="width:165.0pt;border:none;padding:0in 15.0pt 0in 15.0pt;height:37.5pt"><p class="MsoNormal" style="mso-margin-top-alt:7.5pt;margin-right:0in;margin-bottom:7.5pt;margin-left:0in;mso-line-height-alt:8.25pt"><b><span style="font-size:10.0pt;font-family:"Trebuchet MS",sans-serif;color:#4C0097">Arthur Bazin </span></b><span style="font-size:8.5pt;font-family:"Trebuchet MS",sans-serif;color:#4C0097"></span></p><p></p><p></p></td><td width="1" style="width:.75pt;border:none;background:#8000FF;padding:0in 0in 0in 0in;height:37.5pt;background-image:linear-gradient(0deg,rgb(128,0,255),rgb(0,159,255))"></td><td width="220" style="width:165.0pt;border:none;padding:0in 15.0pt 0in 15.0pt;height:37.5pt"><p class="MsoNormal" style="mso-margin-top-alt:7.5pt;margin-right:0in;margin-bottom:7.5pt;margin-left:0in;mso-line-height-alt:8.25pt"><i><span style="font-size:8.5pt;font-family:"Trebuchet MS",sans-serif;color:#B4B4B4">We are all made of star stuff - Carl Sagan </span></i><span style="font-size:8.5pt;font-family:"Trebuchet MS",sans-serif;color:#4C0097"></span></p><p></p><p></p></td></tr><tr style="height:7.5pt"><td colspan="3" style="border:none;padding:.75pt .75pt .75pt .75pt;height:7.5pt"></td></tr><tr><td colspan="3" style="border:none;background:#8000FF;padding:11.25pt 7.5pt 11.25pt 7.5pt;background-image:linear-gradient(135deg,rgb(128,0,255),rgb(0,159,255))"><p class="MsoNormal" align="center" style="mso-margin-top-alt:7.5pt;margin-right:0in;margin-bottom:7.5pt;margin-left:0in;text-align:center;mso-line-height-alt:8.25pt"><span style="font-size:8.5pt;font-family:"Trebuchet MS",sans-serif;color:white">Pensez à la planète, merci de n'imprimer ce mail que si cela est vraiment nécessaire </span></p><p></p><p></p></td></tr></tbody></table></div></div></div></div></div></div></div></div><p class="MsoNormal"></p><p> </p></div><p class="MsoNormal"></p><p> </p><div><div><p class="MsoNormal">Le dim. 5 janv. 2025 à 10:06, Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>> a écrit :</p><p></p></div><blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in"><p class="MsoNormal" style="margin-bottom:12.0pt">We are thinking of removing BRIN support in PostGIS because it has a serious<br>bug as discussed here.<br><br><a href="https://lists.osgeo.org/pipermail/postgis-devel/2025-January/030457.html" target="_blank">https://lists.osgeo.org/pipermail/postgis-devel/2025-January/030457.html</a><br><br>and here - <a href="https://trac.osgeo.org/postgis/ticket/5564" target="_blank">https://trac.osgeo.org/postgis/ticket/5564</a><br><br>that currently causes crashes during Index building.<br><br>The two options on the table are:<br><br>1) Fix the issue<br>2) Remove BRIN Support<br><br><br>I'm leaning toward the removal of BRIN support because I see no point<br>carrying the technical baggage of continuously supporting BRIN and testing<br>it <br>if very very few people are using it. Yes this will be a breaking change<br>for those that use it.<br><br>Thanks,<br>Regina</p><p></p></blockquote></div></div></div></blockquote></div></body></html>