Re: spgist index not getting used - Mailing list pgsql-general

From Paul Ramsey
Subject Re: spgist index not getting used
Date
Msg-id etPan.5423637b.6b8b4567.13d2f@Crane.local
Whole thread Raw
In response to Re: spgist index not getting used  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
List pgsql-general
Still no go. I actually tried a bunch of different selectivity functions too, and the planner correctly used them to
estimatethe number of potential returned functions, but in no case did the index actually kick in, no matter how
selectiveI made the operator appear.  

P.


--
http://postgis.net
http://cleverelephant.ca


On September 24, 2014 at 4:32:35 PM, Peter Geoghegan (peter.geoghegan86@gmail.com) wrote:
> On Wed, Sep 24, 2014 at 2:01 PM, Paul Ramsey wrote:
> > If I build an index on the same table using the internal quad-tree ops, and
> > use their operator, I do get an index scan.
>
>
> What about when enable_seqscan = off?
>
> --
> Regards,
> Peter Geoghegan
>



pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Synchronous replication + pgPool: not all transactions immediately visible on standby
Next
From: Tom Lane
Date:
Subject: Re: spgist index not getting used