Re: [QUESTION/PROPOSAL] loose quadtree in spgist

2020-01-08 Thread Tom Lane
Peter Griggs writes: > In the getQuadrant function in the file src/backend/utils/adt/geo_spgist.c, > I only added some elog statements to see the quadrant that a box is placed > into using the current code. getQuadrant is called several times by the > spg_box_quad_picksplit function, which is used

Re: [QUESTION/PROPOSAL] loose quadtree in spgist

2020-01-08 Thread Peter Griggs
Thank you for the tips Tomas, I really appreciate it. You're definitely right that I should include code snippets, so here's the code i'm trying to change. In the getQuadrant function in the file src/backend/utils/adt/geo_spgist.c, I only added some elog statements to see the quadrant that a box i

Re: [QUESTION/PROPOSAL] loose quadtree in spgist

2020-01-07 Thread Tomas Vondra
On Tue, Jan 07, 2020 at 11:33:31AM -0500, Peter Griggs wrote: Hello, I wanted some guidance/suggestions about creating an spgist extension. For context, i am a grad student doing research that involves comparing the performance of different indexes for spatial data. We've built a system that uses

[QUESTION/PROPOSAL] loose quadtree in spgist

2020-01-07 Thread Peter Griggs
Hello, I wanted some guidance/suggestions about creating an spgist extension. For context, i am a grad student doing research that involves comparing the performance of different indexes for spatial data. We've built a system that uses Postgres and one of the data structures we want to use is a loo