Re: [PATCH] heap_insert() and heap_update() optimization

From: Andres Freund <andres(at)anarazel(dot)de>
To: Andrey Klychkov <aaklychkov(at)mail(dot)ru>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCH] heap_insert() and heap_update() optimization
Date: 2018-10-17 06:53:04
Message-ID: 20181017065304.pp45nuq2k5ov7wcq@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 2018-10-17 09:48:19 +0300, Andrey Klychkov wrote:
> > Interesting. That's with an optimized build, or an assertion build?
>
> Hello,
> That was an optimized build.
>
> However I've just done some extra time tests and didn't notice so significant difference as early.
> Even more - avg origin 1272, avg patched 1303.
>
> Maybe there was the autovacuum / analyze / checkpoint or something else that could influence on the yesterday tests.

Probably worth looking at the generated code. I can see some difference,
but what you measured seemed pretty large.

Greetings,

Andres Freund

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Haribabu Kommi 2018-10-17 07:38:05 Re: View to get all the extension control file details
Previous Message Andrey Klychkov 2018-10-17 06:48:19 Re[2]: [PATCH] heap_insert() and heap_update() optimization