Re: BufferAlloc: don't take two simultaneous locks

From: Yura Sokolov <y(dot)sokolov(at)postgrespro(dot)ru>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, michail(dot)nikolaev(at)gmail(dot)com, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Andres Freund <andres(at)anarazel(dot)de>, Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com>
Subject: Re: BufferAlloc: don't take two simultaneous locks
Date: 2022-04-22 08:49:56
Message-ID: 9651bd3ebd1316cb6dac0fa441bdb5c3884234a5.camel@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Btw, I've runned tests on EPYC (80 cores).

1 key per select
conns | master | patch-v11 | master 1G | patch-v11 1G
--------+------------+------------+------------+------------
1 | 29053 | 28959 | 26715 | 25631
2 | 53714 | 53002 | 55211 | 53699
3 | 69796 | 72100 | 72355 | 71164
5 | 118045 | 112066 | 122182 | 119825
7 | 151933 | 156298 | 162001 | 160834
17 | 344594 | 347809 | 390103 | 386676
27 | 497656 | 527313 | 587806 | 598450
53 | 732524 | 853831 | 906569 | 947050
83 | 823203 | 991415 | 1056884 | 1222530
107 | 812730 | 930175 | 1004765 | 1232307
139 | 781757 | 938718 | 995326 | 1196653
163 | 758991 | 969781 | 990644 | 1143724
191 | 774137 | 977633 | 996763 | 1210899
211 | 771856 | 973361 | 1024798 | 1187824
239 | 756925 | 940808 | 954326 | 1165303
271 | 756220 | 940508 | 970254 | 1198773
307 | 746784 | 941038 | 940369 | 1159446
353 | 710578 | 928296 | 923437 | 1189575
397 | 715352 | 915931 | 911638 | 1180688

3 keys per select

conns | master | patch-v11 | master 1G | patch-v11 1G
--------+------------+------------+------------+------------
1 | 17448 | 17104 | 18359 | 19077
2 | 30888 | 31650 | 35074 | 35861
3 | 44653 | 43371 | 47814 | 47360
5 | 69632 | 64454 | 76695 | 76208
7 | 96385 | 92526 | 107587 | 107930
17 | 195157 | 205156 | 253440 | 239740
27 | 302343 | 316768 | 386748 | 335148
53 | 334321 | 396359 | 402506 | 486341
83 | 300439 | 374483 | 408694 | 452731
107 | 302768 | 369207 | 390599 | 453817
139 | 294783 | 364885 | 379332 | 459884
163 | 272646 | 344643 | 376629 | 460839
191 | 282307 | 334016 | 363322 | 449928
211 | 275123 | 321337 | 371023 | 445246
239 | 263072 | 341064 | 356720 | 441250
271 | 271506 | 333066 | 373994 | 436481
307 | 261545 | 333489 | 348569 | 466673
353 | 255700 | 331344 | 333792 | 455430
397 | 247745 | 325712 | 326680 | 439245

Attachment Content-Type Size
image/gif 12.7 KB
image/gif 12.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gilles Darold 2022-04-22 09:57:05 Re: [Proposal] vacuumdb --schema only
Previous Message Aleksander Alekseev 2022-04-22 08:33:56 Re: RFC: compression dictionaries for JSONB