Re: Signed vs Unsigned (take 2) (src/backend/storage/ipc/procarray.c)

From: Ranier Vilela <ranier(dot)vf(at)gmail(dot)com>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Signed vs Unsigned (take 2) (src/backend/storage/ipc/procarray.c)
Date: 2021-06-15 00:01:19
Message-ID: CAEudQAr4qPbZkjLoHF9SSnc7ddOLdguU+mkRZt2BeOCk-exe1w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I took it a step further.

Transactions

HEAD patched
10002207 10586781
10146167 10388685
10048919 10333359
10065764,3333333 10436275 3,55021946687555

TPS
HEAD patched
33469,016009 35399,010472
33950,624679 34733,252336
33639,8429 34578,495043
33686,4945293333 34903,5859503333 3,48700968070122

3,55% Is it worth touch procarray.c for real?

With msvc 64 bits, the asm generated:
HEAD
213.731 bytes procarray.asm
patched
212.035 bytes procarray.asm

Patch attached.

regards,
Ranier Vilela

Attachment Content-Type Size
improve_procarray.patch application/octet-stream 28.9 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2021-06-15 00:23:21 Re: Teaching users how they can get the most out of HOT in Postgres 14
Previous Message Jason Kim 2021-06-14 22:33:06 Re: [PATCH] Fix select from wrong table array_op_test