Re: Bug in new buffering GiST build code
От | Heikki Linnakangas |
---|---|
Тема | Re: Bug in new buffering GiST build code |
Дата | |
Msg-id | 4FC5E1FF.4060102@enterprisedb.com обсуждение исходный текст |
Ответ на | Re: Bug in new buffering GiST build code (Alexander Korotkov <aekorotkov@gmail.com>) |
Ответы |
Re: Bug in new buffering GiST build code
|
Список | 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 по дате отправления: