From: | arjun shetty <arjunshetty955(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)lists(dot)postgresql(dot)org |
Subject: | PostgreSQLv14 performance client-server-HammerDB |
Date: | 2021-12-16 15:35:03 |
Message-ID: | CAMowxTvH27BqDhroVKPU5cx5DBjWqZPqX0Jp+qGHBue8qXhUfQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi ,
PostgreSQLv14 source build/compiled with GCCv11.1 and bin's run different
machine like single machine and client-server machine.
observed Single Milan machine, the NOPM is more or less half with the
Client-Server method.
And checked the network bandwidth on Client-Server machine, it is similar
bandwidth(transmit request and receive) and tcp/udp ports same bandwidth.
Only the difference in Client-Server is RAM size and Cache(L1/L2/L3). is
this cause drop in NOPM?
Is another recommend configurations or parameters need to check via
HammerDBv4.x
In Client-server model(HammerDBv4.x run in Client and PostgreSQLv14 run in
Server Model)
12 VU:NOPM 431811)
On Single or Sole Machine (both HammerDBv4.x & PostgreSQLv14 run same
machine )
12 VU: NOPM:728825
From | Date | Subject | |
---|---|---|---|
Next Message | Lars Bergeson | 2021-12-21 01:23:54 | Query is slower with a large proportion of NULLs in several columns |
Previous Message | Imre Samu | 2021-12-10 18:21:26 | Re: PostgreSQLv14 TPC-H performance GCC vs Clang |