[PATCH] heap_insert() and heap_update() optimization - Mailing list pgsql-hackers

From Andrey Klychkov
Subject [PATCH] heap_insert() and heap_update() optimization
Date
Msg-id 1539678497.898777998@f532.i.mail.ru
Whole thread Raw
Responses Re: [PATCH] heap_insert() and heap_update() optimization  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers

Hello, hackers

I suggest the small attached patch that gives a bit of heap_insert() and heap_update() optimization
by reducing calls of BufferGetPage(buffer) into them.

I measured call time of these:
heap_insert(): avg origin 13394 ns, avg patched 12685 ns; perf increases +5.59%
heap_update(): avg origin 15728 ns, avg patched 13936 ns; perf increases +11.39%

This can be notable when there are handling many rows.
--
Regards,
Andrew K.

Attachment

pgsql-hackers by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Function to promote standby servers
Next
From: John Naylor
Date:
Subject: Re: WIP: Avoid creation of the free space map for small tables