Re: WIP: Fast GiST index build

From: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: WIP: Fast GiST index build
Date: 2011-06-20 07:46:28
Message-ID: BANLkTin=gyX5PJW-JaN59uqRBSgdDHVNNA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

New version of patch. There are some bugfixes, minor refactoring, comments
(unfortunatelly, not all the code is covered by comments yet). Also
"fastbuild" parameter was added to the GiST index. It allows to test index
building with and without fast build without postgres recompile.

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

On Thu, Jun 16, 2011 at 10:35 PM, Alexander Korotkov
<aekorotkov(at)gmail(dot)com>wrote:

> Oh, actually it's so easy. Thanks.
>
> ------
> With best regards,
> Alexander Korotkov.
>
> On Thu, Jun 16, 2011 at 10:26 PM, Heikki Linnakangas <
> heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
>
>> On 16.06.2011 21:13, Alexander Korotkov wrote:
>>
>>> My current idea is to measure number of IO accesses by pg_stat_statements
>>> and measure CPU usage by /proc/PID/stat. Any thoughts?
>>>
>>
>> Actually, you get both of those very easily with:
>>
>> set log_statement_stats=on
>>
>> LOG: QUERY STATISTICS
>> DETAIL: ! system usage stats:
>> ! 0.000990 elapsed 0.000000 user 0.000000 system sec
>> ! [0.000000 user 0.008000 sys total]
>> ! 0/0 [32/0] filesystem blocks in/out
>> ! 0/0 [0/959] page faults/reclaims, 0 [0] swaps
>> ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
>> ! 0/0 [10/1] voluntary/involuntary context switches
>> STATEMENT: SELECT generate_series(1,100);
>>
>>
>>
>> --
>> Heikki Linnakangas
>> EnterpriseDB http://www.enterprisedb.com
>>
>
>

Attachment Content-Type Size
gist_fast_build-0.2.0.patch.gz application/x-gzip 22.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2011-06-20 08:48:49 Re: ALTER TABLE lock strength reduction patch is unsafe
Previous Message Radosław Smogura 2011-06-20 07:07:19 Re: Patch - Debug builds without optimization