Re: Is there a point to having both a normal gist index and an exclude index?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Is there a point to having both a normal gist index and an exclude index?
Дата
Msg-id 28169.1491422183@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Is there a point to having both a normal gist indexand an exclude index?  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-general
Bruno Wolff III <bruno@wolff.to> writes:
> P.S. Using spgist with version 10 for the exclude index is much faster
> than using gist in 9.6. I have run the index creation for as long as
> 6 hours and it hasn't completed with 9.6. It took less than 10 minutes
> to create it in 10. For this project using 10 isn't a problem and I'll
> be doing that.

Interesting.  That probably traces back to Emre Hasegeli's work from
last year (commit 77e290682).

            regards, tom lane


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Unexpected interval comparison
Следующее
От: George Neuner
Дата:
Сообщение: Re: browser interface to forums please?