Re: GIN improvements part 1: additional information

From: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
Cc: Tomas Vondra <tv(at)fuzzy(dot)cz>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: GIN improvements part 1: additional information
Date: 2014-01-24 11:33:59
Message-ID: CAPpHfdv9RoHM8AAYxcLcHneiJOQC0GwA1QnFf8x255gDsvQW1Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jan 24, 2014 at 1:19 PM, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com
> wrote:

> On 01/24/2014 10:53 AM, Alexander Korotkov wrote:
>
>> OK. What about previous fix in assert?
>>
>
> Ah right, fixed that too now.

Good, now my test-suite passed. Results are so.

Time of operations
event | period
-----------------------+-----------------
index_build | 00:01:45.709546
index_build_recovery | 00:00:09
index_update | 00:05:45.732214
index_update_recovery | 00:01:17
search_new | 00:24:02.191049
search_updated | 00:26:54.122852
(6 rows)

Index sizes
label | size
---------------+-----------
new | 387547136
after_updates | 610877440
(2 rows)

Before compression results were following.

Time of operations
event | period
-----------------------+-----------------
index_build | 00:01:51.116722
index_build_recovery | 00:00:08
index_update | 00:05:12.124758
index_update_recovery | 00:01:43
search_new | 00:23:44.281424
search_updated | 00:25:41.96251
(6 rows)

Index sizes
label | size
---------------+------------
new | 884514816
after_updates | 1595252736
(2 rows)

So, we can see little regression. However, I'm not sure if it's very
significant.

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message MauMau 2014-01-24 11:37:55 Re: Recovery to backup point
Previous Message Dean Rasheed 2014-01-24 11:16:42 Re: Infinite recursion in row-security based on updatable s.b. views