| From: | Alexander Korotkov <aekorotkov(at)gmail(dot)com> |
|---|---|
| To: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Bug in new buffering GiST build code |
| Date: | 2012-06-05 06:45:37 |
| Message-ID: | CAPpHfdsGmBZCM9MX3d4jMCXZ-BAWPTyoDUsZkTRKpWhq8tcGWQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Jun 5, 2012 at 2:00 AM, Alexander Korotkov <aekorotkov(at)gmail(dot)com>wrote:
> On Mon, May 28, 2012 at 1:46 AM, Alexander Korotkov <aekorotkov(at)gmail(dot)com>wrote:
>
>> On Sat, May 26, 2012 at 12:33 AM, Heikki Linnakangas <
>> heikki(dot)linnakangas(at)enterprisedb(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2012-06-05 06:48:16 | Re: Bug in new buffering GiST build code |
| Previous Message | Noah Misch | 2012-06-05 06:37:30 | Re: Unnecessary WAL archiving after failover |