Paul Ramsey <pramsey@cleverelephant.ca> writes:
> My C implementation is here https://github.com/pramsey/postgis/blob/spgist/postgis/gserialized_spgist_2d.c
> My SQL binding calls are here https://github.com/pramsey/postgis/blob/spgist/postgis/gserialized_spgist_2d.sql
> Thanks to help from Andres Freund, I can now build an index based on my extension. However, when I run a query using
theoperator(s) I have defined, the query never uses my index, it always sequence scans.
> explain analyze select * from somepoints where '(5898.82450178266,7990.24286679924)'::point = pt;
(I assume that's a typo and you meant "... &=& pt")
As stated, this WHERE clause cannot be used with the index: indexable
clauses in PG are always of the form "indexed_column operator something",
and you've written it the other way round. I gather that you think the
operator is commutative; but since you didn't declare that, the planner
doesn't know it can flip the clause around. Try adding "commutator = &=&"
to the declaration of the "point &=& point" operator.
regards, tom lane