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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Is there a point to having both a normal gist index and an exclude index?
Date: 2017-04-05 19:56:23
Message-ID: 28169.1491422183@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bruno Wolff III <bruno(at)wolff(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message George Neuner 2017-04-05 20:31:50 Re: browser interface to forums please?
Previous Message Tom Lane 2017-04-05 19:51:10 Re: Unexpected interval comparison