Re: WIP: Fast GiST index build - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: WIP: Fast GiST index build
Date
Msg-id CAPpHfdu9DbRQ93ACxBaDNDwCyAJpstHRubTjjY5eCbYeYkM7bg@mail.gmail.com
Whole thread Raw
In response to Re: WIP: Fast GiST index build  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
On Tue, Jul 26, 2011 at 9:24 PM, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:
That was a quite off-the-cuff remark, so I took the patch and culled out loaded-tree bookkeeping. A lot of other changes fell off from that, so it took me quite some time to get it working again, but here it is. This is a *lot* smaller patch, although that's partly explained by the fact that I left out some features: prefetching and the neighbor relocation code is gone.

I'm pretty exhausted by this, so I just wanted to send this out without further analysis. Let me know if you have questions on the approach taken. I'm also not sure how this performs compared to your latest patch, I haven't done any performance testing. Feel free to use this as is, or as a source of inspiration :-).
I also was going to try to evade keeping loaded-tree hash. This might help me a lot. Thanks.

------
With best regards,
Alexander Korotkov.

pgsql-hackers by date:

Previous
From: Yeb Havinga
Date:
Subject: Pull up aggregate sublink (was: Parameterized aggregate subquery (was: Pull up aggregate subquery))
Next
From: Simon Riggs
Date:
Subject: Re: sinval synchronization considered harmful