On Sun, May 27, 2018 at 2:09 PM, Peter Geoghegan <p...@bowt.ie> wrote: > On Sun, May 27, 2018 at 12:45 PM, Jonathan S. Katz <jk...@postgresql.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
