Re: SP-GiST failing to complete SP-GiST index build

On Sun, May 27, 2018 at 2:09 PM, Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> On Sun, May 27, 2018 at 12:45 PM, Jonathan S. Katz <jkatz(at)postgresql(dot)org> wrote:
>> Next, see bad.sql. 1.2MM sparsely clustered rows inserted, GiST indexes
>> builds in about 30s on my machine. SP-GiST does not build at all, or at
>> least I have been composing this email for about 10 minutes since I kicked
>> off my latest and it has yet to terminate.
>>
>> I can understand this being an extreme case for SP-GiST as it’s better
>> for data set that’s more densely clustered, but I wanted to provide
>> this info to rule out whether or not this is a bug.
>
> While I'm no SP-GiST expert, I strongly suspect that you've identified
> a real bug here. Your test case has been running on my development
> machine for 20 minutes now (this is server class hardware).

Looks like I spoke too soon. The SP-GiST index build finished a moment
ago. The index build took a horrifically long time for a 122 MB index,
though.

--
Peter Geoghegan