[PATCH] heap_insert() and heap_update() optimization

From: Andrey Klychkov <aaklychkov(at)mail(dot)ru>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: [PATCH] heap_insert() and heap_update() optimization
Date: 2018-10-16 08:28:17
Message-ID: 1539678497.898777998@f532.i.mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
v1-00-heap_insert-and-heap_update_optimized.patch application/x-patch 2.3 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message John Naylor 2018-10-16 10:57:25 Re: WIP: Avoid creation of the free space map for small tables
Previous Message Laurenz Albe 2018-10-16 07:49:20 Re: Function to promote standby servers