Re: Bug in new buffering GiST build code

Поиск
Список
Период
Сортировка
От Alexander Korotkov
Тема Re: Bug in new buffering GiST build code
Дата
Msg-id CAPpHfdsGmBZCM9MX3d4jMCXZ-BAWPTyoDUsZkTRKpWhq8tcGWQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Bug in new buffering GiST build code  (Alexander Korotkov <aekorotkov@gmail.com>)
Ответы Re: Bug in new buffering GiST build code  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
On Tue, Jun 5, 2012 at 2:00 AM, Alexander Korotkov <aekorotkov@gmail.com> wrote:
On Mon, May 28, 2012 at 1:46 AM, Alexander Korotkov <aekorotkov@gmail.com> wrote:
On Sat, May 26, 2012 at 12:33 AM, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:
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.

I rerun some of tests. There are index build times in seconds for old way of parent refind and new way of it.

                  old      new
usnoa2           2385     2452
usnoa2_shuffled  8131     8055
uniform          8327     8359

I thinks difference can be described by round error.

Oh, I mean not "round" error, but "random". I.e. not exactly same state of shared buffers at index build start and so on.
 
------
With best regards,
Alexander Korotkov.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: Unnecessary WAL archiving after failover
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Bug in new buffering GiST build code