Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Geoghegan
Subject Re: spgist index not getting used
Date
Msg-id CAEYLb_Vns+mxyQ4yfr+zPtuQ56OJZ-SGw18J9xg7c1WQK7aFkQ@mail.gmail.com
Whole thread Raw
In response to spgist index not getting used  (Paul Ramsey <pramsey@cleverelephant.ca>)
Responses Re: spgist index not getting used
List pgsql-general
Tree view 
On Wed, Sep 24, 2014 at 2:01 PM, Paul Ramsey <pramsey@cleverelephant.ca> 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: Paul Ramsey
Date:
Subject: spgist index not getting used
Next
From: Tatsuo Ishii
Date:
Subject: Re: Synchronous replication + pgPool: not all transactions immediately visible on standby