Postgres Pro
Downloads
Home   >   mailing lists

Re: Signed vs Unsigned (take 2) (src/backend/storage/ipc/procarray.c) - Mailing list pgsql-hackers

From Ranier Vilela
Subject Re: Signed vs Unsigned (take 2) (src/backend/storage/ipc/procarray.c)
Date
Msg-id CAEudQAr4qPbZkjLoHF9SSnc7ddOLdguU+mkRZt2BeOCk-exe1w@mail.gmail.com
Whole thread Raw
In response to Re: Signed vs Unsigned (take 2) (src/backend/storage/ipc/procarray.c)  (Ranier Vilela <ranier.vf@gmail.com>)
Responses Re: Signed vs Unsigned (take 2) (src/backend/storage/ipc/procarray.c)
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: Jason Kim
Date:
Subject: Re: [PATCH] Fix select from wrong table array_op_test
Next
From: Michael Paquier
Date:
Subject: Re: Teaching users how they can get the most out of HOT in Postgres 14