Re: pgbench - extend initialization phase control

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com>
Cc: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: pgbench - extend initialization phase control
Date: 2019-06-11 04:43:13
Message-ID: alpine.DEB.2.21.1906110638010.9922@lancre
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hello Ibrar,

> Does both client/server side data generation in a single command make
> sense?

I think yes, especially with the other patch which adds timing measures to
the initialization phases. It really depends what you want to test.

With client-side generation you test the libpq COPY interface and network
protocol for bulk loading.

With server-side generation you are get the final result faster when
network bandwidth is low, and somehow you are testing a different kind of
small query which generates a lot of data.

--
Fabien.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Etsuro Fujita 2019-06-11 04:45:20 Re: postgres_fdw: unordered C includes
Previous Message Amit Langote 2019-06-11 04:31:13 Re: BEFORE UPDATE trigger on postgres_fdw table not work