PostgreSQLv14 performance client-server-HammerDB - Mailing list pgsql-performance

From arjun shetty
Subject PostgreSQLv14 performance client-server-HammerDB
Date
Msg-id CAMowxTvH27BqDhroVKPU5cx5DBjWqZPqX0Jp+qGHBue8qXhUfQ@mail.gmail.com
Whole thread Raw
List 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

pgsql-performance by date:

Previous
From: Imre Samu
Date:
Subject: Re: PostgreSQLv14 TPC-H performance GCC vs Clang
Next
From: Lars Bergeson
Date:
Subject: Query is slower with a large proportion of NULLs in several columns