Re: Is there a point to having both a normal gist index and an exclude index? - Mailing list pgsql-general

From Tom Lane
Subject Re: Is there a point to having both a normal gist index and an exclude index?
Date
Msg-id 28169.1491422183@sss.pgh.pa.us
Whole thread Raw
In response to Re: Is there a point to having both a normal gist indexand an exclude index?  (Bruno Wolff III <bruno@wolff.to>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unexpected interval comparison
Next
From: George Neuner
Date:
Subject: Re: browser interface to forums please?