Re: Bug in new buffering GiST build code - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Bug in new buffering GiST build code
Date
Msg-id 4FC5E1FF.4060102@enterprisedb.com
Whole thread Raw
In response to Re: Bug in new buffering GiST build code  (Alexander Korotkov <aekorotkov@gmail.com>)
Responses Re: Bug in new buffering GiST build code
List pgsql-hackers
On 28.05.2012 00:46, Alexander Korotkov wrote:
> On Sat, May 26, 2012 at 12:33 AM, Heikki Linnakangas<
> heikki.linnakangas@enterprisedb.com>  wrote:
>
>> Attached is a patch to replace the path stacks with a hash table. With
>> this patch, the index build time in my test case dropped from 59 minutes to
>> about 55 minutes. I don'ẗ know how representative or repeatable this test
>> case is, but this definitely seems very worthwhile, not only because it
>> fixes the bug and makes the code simpler, but also on performance grounds.
>
> Cool, seems that we've both simplier and faster implementation of finding
> parent. Thanks!

Ok, I committed this now.

I also spotted and fixed another little oversight: the temporary file 
didn't get deleted after the index build.

>> Alexander, do you still have the test environments and data lying around
>> that you used for GiST buffering testing last summer? Could you rerun some
>> of those tests with this patch?
>
> I think I can restore test environment and data. Will rerun tests soon.

Thanks!

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: hash index concurrency
Next
From: Alexander Korotkov
Date:
Subject: Re: Bug in new buffering GiST build code