From: Tom Lane <tgl@sss.pgh.pa.us>
To: Gilles Bernard <gbernard@matra-ms2i.fr>
Cc: Ralf Mattes <rm@mh-freiburg.de>
Cc: pgsql-docs@postgresql.org
Subject: Re: Postgres ignoring RTree for geometric operators
Date: Wed, 03 Jan 2001 11:24:46 -0500
Message-ID: <16360.978539086@sss.pgh.pa.us> (raw)
In-Reply-To: <200101031611.RAA08449@fwm1.matra-ms2i.fr>
References: <200012290946.KAA01221@fwm1.matra-ms2i.fr>
<14474.978302554@sss.pgh.pa.us>
<20010101145354.A8897@forte.mh-freiburg.de>
<23227.978375037@sss.pgh.pa.us>
<200101031611.RAA08449@fwm1.matra-ms2i.fr>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: tgl@sss.pgh.pa.us, gbernard@matra-ms2i.fr, rm@mh-freiburg.de
Subject: Re: Postgres ignoring RTree for geometric operators
In-Reply-To: <16360.978539086@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox