[postgis-devel] [SoC] "Gsoc weekly report 4": Implement sp-gist clustering in PostGIS and cartoDB

Sandro Santilli strk at keybit.net
Wed Jun 18 06:26:23 PDT 2014

On Wed, Jun 18, 2014 at 06:05:34PM +0530, mohit kumar wrote:
> Hi Strk,
> Can you give me some references on how to write a postGIS connector  and
> what exactly do we want. I am getting confused in a lot of things.

We want to be able to do:

CREATE INDEX ON the_table USING spgist (the_geom);

Then, (second step?):

-- This query should use the spgist index
EXPLAIN SELECT * FROM the_table WHERE the_geom && <small_bbox>;


More information about the postgis-devel mailing list