PGBench on Windows - connections are subprocesses?

From: Durumdara <durumdara(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: PGBench on Windows - connections are subprocesses?
Date: 2020-07-20 13:20:54
Message-ID: CAEcMXhmkiNiz56qgtyjLLstA4yZu-U6v7GeyP3Q3cNDBRm+igw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear Members!

I have a question about PGBench for Windows (9,6).

I want to understand the working method of this tool for use well
in the test series.

This has more options, like connections (c).

As I tried the c controls how much concurrent connections must be used in
the test. For example c 10 increases with ten. It's ok.

But the number of threads option (j I think) confused me. At first I
thought the total connection number is simply the multiplication of c and j
(subconnections).
As I saw this is untrue.

So I don't know how this utility works really in the background.

a.)
It makes C subprocesses with connections and every of them makes his work
concurrently?

b.)
It makes N connections on one thread/process. Hut only one works at the
same time. J controls how much works at the same time. The other
connections are sleeping.
1. c started/has finished.
2. c started/has finished.
N. c started/has finished.
End.
(This is a little bit senseless)

c.)
It makes C subthreads and every thread has it's connection. They work
concurrently (like in case a).
It could be ok, but why can I set threads with the "j" option - when
subthreads must be equal with the number of connections.

Do you know something about the background of this utility?

We have to move to the next server which is different from the actual one,
and I need to measure them to detect the possible problems.
To compare the result I must understand the operations.

Very-very thank you for each answer you write!

Best regards
DD

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-07-20 13:37:56 Re: Steps required for increasing disk size in EC2 instance with minimal downtime
Previous Message Francisco Olarte 2020-07-20 10:56:37 Re: Improvement for query planner? (no, not about count(*) again ;-))