Re: Postgres ignoring RTree for geometric operators - Mailing list pgsql-docs

From Tom Lane
Subject Re: Postgres ignoring RTree for geometric operators
Date
Msg-id 16360.978539086@sss.pgh.pa.us
Whole thread Raw
In response to Postgres ignoring RTree for geometric operators  ("Gilles Bernard" <gbernard@matra-ms2i.fr>)
List pgsql-docs
"Gilles Bernard" <gbernard@matra-ms2i.fr> writes:
> I tryed all you suggested me : (forme && '((...))'), drop the index and
> recreate it and do a vacuum analyze and it
> still do a sequential scan on the whole table.

Hm.  You might try reducing the selectivity estimates returned by
areasel() and friends in src/backend/utils/adt/geo_selfuncs.c.
I thought they were small enough already, but perhaps not.

            regards, tom lane

pgsql-docs by date:

Previous
From: anson
Date:
Subject: Sequence
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Re: Inheritance docs error.