Re: spgist index not getting used

From: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
To: Paul Ramsey <pramsey(at)cleverelephant(dot)ca>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: spgist index not getting used
Date: 2014-09-24 23:32:35
Message-ID: CAEYLb_Vns+mxyQ4yfr+zPtuQ56OJZ-SGw18J9xg7c1WQK7aFkQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Sep 24, 2014 at 2:01 PM, Paul Ramsey <pramsey(at)cleverelephant(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tatsuo Ishii 2014-09-24 23:40:52 Re: Synchronous replication + pgPool: not all transactions immediately visible on standby
Previous Message Paul Ramsey 2014-09-24 21:01:40 spgist index not getting used