From: | Vasya <m7onov(at)yandex(dot)ru> |
---|---|
To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | [PATCH] Check system cache invalidations before each command in transaction |
Date: | 2022-10-06 18:04:44 |
Message-ID: | e8d233f66deff2620406062f531da958f58c2331.camel@yandex.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello guys.
In the previous discussion [1] we find out that while we are in
transaction function definition is not invalidated if it was redefined
in another session. Here is a patch to fix this. Also, I did a small
perfomance impact measurement (test.sh in attachment) on my home PC
with Intel(R) Core(TM) i7-8700 CPU @ 3.20GHz. The result is (each
transaction is a 10 million calls to functions):
- without patch
latency average = 37087.639 ms
tps = 0.026963
- with patch
latency average = 38793.125 ms
tps = 0.025778
What do you think about it, guys?
[1]
https://www.postgresql.org/message-id/flat/1205251664297977%40mail.yandex.ru
Attachment | Content-Type | Size |
---|---|---|
0001-Check-system-cache-invalidations-before-each-command.patch | text/x-patch | 1.5 KB |
test.sh | application/x-shellscript | 1.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2022-10-06 18:19:21 | Re: Reducing the chunk header sizes on all memory context types |
Previous Message | Nathan Bossart | 2022-10-06 17:43:43 | Re: use has_privs_of_role() for pg_hba.conf |