Re: spgist index not getting used

Поиск
Список
Период
Сортировка
От Paul Ramsey
Тема Re: spgist index not getting used
Дата
Msg-id etPan.5423637b.6b8b4567.13d2f@Crane.local
обсуждение исходный текст
Ответ на Re: spgist index not getting used  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: Synchronous replication + pgPool: not all transactions immediately visible on standby
Следующее
От: Tom Lane
Дата:
Сообщение: Re: spgist index not getting used