postgrespro/pgsphere

Add BRIN support for spoint and sbox?

Closed this issue ยท 3 comments

Would incorporating this PR be useful to anyone? It was fully working but never merged. It seems a waste to not retain this functionality, and it could be a real benefit when dealing with very large tables with millions of points.

See akorotkov/pgsphere#8 and this comment.

Hi, I see @vitcpp already opened a PR here (will leave comments there eventually). I'm happy to help if needed.

@gbroccolo Thank you for the patch! I preserved your authorship of the patch with some code adjustments. I believe, you don't mind if the patch will be applied in this repo. We also appreciate it if you will open some new PRs in this repo that seems to be the only alive repo of the pgSphere project.

Hi @vitcpp fine. Will try to open new PRs, each one for each spherical geometry, any sooner. I will probably start with the circular type, as requested by @esabol.