Re: BufferAlloc: don't take two simultaneous locks - Mailing list pgsql-hackers

From Yura Sokolov
Subject Re: BufferAlloc: don't take two simultaneous locks
Date
Msg-id 9651bd3ebd1316cb6dac0fa441bdb5c3884234a5.camel@postgrespro.ru
Whole thread Raw
In response to Re: BufferAlloc: don't take two simultaneous locks  (Yura Sokolov <y.sokolov@postgrespro.ru>)
List 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

pgsql-hackers by date:

Previous
From: Aleksander Alekseev
Date:
Subject: Re: RFC: compression dictionaries for JSONB
Next
From: Gilles Darold
Date:
Subject: Re: [Proposal] vacuumdb --schema only