Skip site navigation (1) Skip section navigation (2)

Re: Postgres ignoring RTree for geometric operators

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gilles Bernard" <gbernard(at)matra-ms2i(dot)fr>
Cc: "Ralf Mattes" <rm(at)mh-freiburg(dot)de>, pgsql-docs(at)postgresql(dot)org
Subject: Re: Postgres ignoring RTree for geometric operators
Date: 2001-01-03 16:24:46
Message-ID: 16360.978539086@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-docs
"Gilles Bernard" <gbernard(at)matra-ms2i(dot)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

In response to

pgsql-docs by date

Next:From: Tom LaneDate: 2001-01-03 16:40:43
Subject: Re: [HACKERS] Re: Inheritance docs error.
Previous:From: Gilles BernardDate: 2001-01-03 15:09:35
Subject: Re: Postgres ignoring RTree for geometric operators

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group