Re: PGBench on Windows - connections are subprocesses?

Поиск
Список
Период
Сортировка
От Durumdara
Тема Re: PGBench on Windows - connections are subprocesses?
Дата
Msg-id CAEcMXhkZCZtj3nsT1d4KVD6w0XZ3qEOULaYozOSwzFAm0tVcUg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PGBench on Windows - connections are subprocesses?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
Dear Tom!

Tom Lane <tgl@sss.pgh.pa.us> ezt írta (időpont: 2020. júl. 20., H, 15:38):

There are -j threads in the pgbench process, and -c connections to
the server (hence -c backend processes on the server side).  Each
of the pgbench threads is responsible for sending queries to a subset
of the connections.  Setting -j more than -c is useless (I forget
if it's actually an error).  If you set -j to, say, half of -c then
each thread has exactly two connections to manage.  If -j is too
small compared to -c then pgbench itself tends to become the bottleneck.

Without -j, we have N connections, but one thread.
So this thread serves all of the connections one by one? The 1. and 2. and 3. connection while others do nothing (standing by)?
Or like Round Robin: a job from C1, next job from C2, .... job from CN - then job from C1.... and no more jobs?

And if J = C means realtime parallel test?
Because each thread has only one connection, and they work concurrently as real users do?

Then if I want to simulate 500 users heavy work, I need to set J=C=500?

Thank you for the information!

BW
   DD


 

В списке pgsql-general по дате отправления:

Предыдущее
От: Durumdara
Дата:
Сообщение: Re: PGBench on Windows - connections are subprocesses?
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Logical replication from 11.x to 12.x and "unique key violations"