PostgreSQLv14 performance client-server-HammerDB

Поиск
Список
Период
Сортировка
От arjun shetty
Тема PostgreSQLv14 performance client-server-HammerDB
Дата
Msg-id CAMowxTvH27BqDhroVKPU5cx5DBjWqZPqX0Jp+qGHBue8qXhUfQ@mail.gmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Imre Samu
Дата:
Сообщение: Re: PostgreSQLv14 TPC-H performance GCC vs Clang
Следующее
От: Lars Bergeson
Дата:
Сообщение: Query is slower with a large proportion of NULLs in several columns