Thread: pgbench

pgbench

From
Olga Lytvynova-Bogdanova
Date:
Hello,
Is there a way to integrate pgbench with TeamCity? If yes, could you share very briefly how to do this?
Which volumes of data does pgbench support?
Much appreciated for the attention.

Re: pgbench

From
John R Pierce
Date:
On 12/15/2017 7:37 AM, Olga Lytvynova-Bogdanova wrote:
> Is there a way to integrate pgbench with TeamCity? If yes, could you
> share very briefly how to do this?

I would suspect this is a question for TeamCity, not for postgresql.   I
don't even know what TeamCity actually is (google says 'Continuous
Integration' but thats just a buzz phrase to me).     Can it run shell
scripts?


> Which volumes of data does pgbench support?
I'm unclear what you mean by 'which volumes of data' ?   do you mean,
how large of a dataset does pgbench generate and use?   thats totally
configurable with commandline parameters, from a few dozen kilobytes to
many gigabytes.


--
john r pierce, recycling bits in santa cruz



Re: pgbench

From
Achilleas Mantzios
Date:
On 15/12/2017 23:18, John R Pierce wrote:
> On 12/15/2017 7:37 AM, Olga Lytvynova-Bogdanova wrote:
>> Is there a way to integrate pgbench with TeamCity? If yes, could you share very briefly how to do this?
>
> I would suspect this is a question for TeamCity, not for postgresql.   I don't even know what TeamCity actually is
(googlesays 'Continuous Integration' but thats just a buzz phrase to me).     Can 
 
> it run shell scripts?

We have TeamCity installed, it just listens for git pushes and recompiles and redeploys the application, needs an SQL
database,we use postgresql of course, but it spams the DB so hard it is one of 
 
the rare cases I would say to switch to mysql .
So, I think the OP refers to pgsql not pgbench.

>
>
>> Which volumes of data does pgbench support?
> I'm unclear what you mean by 'which volumes of data' ?   do you mean, how large of a dataset does pgbench generate
anduse? thats totally configurable with commandline parameters, from a few dozen 
 
> kilobytes to many gigabytes.
>
>

-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt