pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedFw: [osdldbt-general] Running DBT5 on remote database server
4+ messages / 4 participants
[nested] [flat]
* Fw: [osdldbt-general] Running DBT5 on remote database server
@ 2013-07-23 02:13 amul sul <sul_amul@yahoo.co.in>
0 siblings, 3 replies; 4+ messages in thread
From: amul sul @ 2013-07-23 02:13 UTC (permalink / raw)
To: pgsql-performance
Hello,
I want test the PostgreSQL performance using DBT5, where my PostgreSQL running on server (say 192.168.56.101) and want to test the performance executing DBT5 on other machine (say 192.168.56.102).
My aim is test the database performance excluding overhead to testing tool running on same machine.
Is this possible using existing DBT5 code or need to modify somehow ?
Thanks and Regards,
Amul Sul
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Fw: [osdldbt-general] Running DBT5 on remote database server
@ 2013-07-25 13:03 Samrat Revagade <revagade.samrat@gmail.com>
parent: amul sul <sul_amul@yahoo.co.in>
2 siblings, 0 replies; 4+ messages in thread
From: Samrat Revagade @ 2013-07-25 13:03 UTC (permalink / raw)
To: pgsql-performance
>I want test the PostgreSQL performance using DBT5, where my PostgreSQL
running on server (say >192.168.56.101) and want to test the performance
executing DBT5 on other machine (say 192.168.56.102).
>My aim is test the database performance excluding overhead to testing tool
running on same machine.
>Is this possible using existing DBT5 code or need to modify somehow ?
Its always beneficial to use a wrapper script on the top of a benchmark.
In such a scenarios you can use two servers (Database server,Test server)
You can run this wrapper script on test server against database server.
In this case the resources of Database servers are used only for running the
benchmark, and Test server can be used for many activities, such as Results
collection ,resource usage collection etc. IOW you can avoid bottleneck of
testing tool.
Greg smith has written a very nice script for pgbnech benchmark.
You can reuse most of the part.
here is the link for that:
https://github.com/gregs1104/pgbench-tools
hope this will be helpful.
Thank you,
Samrat Revagade,
NTT-DATA-OSS Center (Pune)
-----
Thank You,
Samrat.R.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Fw-osdldbt-general-Running-DBT5-on-remote-database-server-tp...
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Fw: [osdldbt-general] Running DBT5 on remote database server
@ 2013-07-25 13:26 sachin kotwal <kotsachin@gmail.com>
parent: amul sul <sul_amul@yahoo.co.in>
2 siblings, 0 replies; 4+ messages in thread
From: sachin kotwal @ 2013-07-25 13:26 UTC (permalink / raw)
To: pgsql-performance
It is always better to run performance script and database on different
machines.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Fw: [osdldbt-general] Running DBT5 on remote database server
@ 2013-07-31 16:02 Greg Smith <greg@2ndQuadrant.com>
parent: amul sul <sul_amul@yahoo.co.in>
2 siblings, 0 replies; 4+ messages in thread
From: Greg Smith @ 2013-07-31 16:02 UTC (permalink / raw)
To: amul sul <sul_amul@yahoo.co.in>; +Cc: pgsql-performance
On 7/22/13 10:13 PM, amul sul wrote:
> I want test the PostgreSQL performance using DBT5, where my PostgreSQL
> running on server (say 192.168.56.101) and want to test the performance
> executing DBT5 on other machine (say 192.168.56.102).
You can do this. Here's the help for the run_workload.sh command:
usage: run_workload.sh -c <number of customers> -d <duration of test> -u
<number of users>
other options:
-a <pgsql>
-b <database parameters>
-f <scale factor. (default 500)>
-h <database host name. (default localhost)>
...
"-h" is the setting that points toward another server. You will also
need to setup the postgresql.conf and pg_hba.conf on the system to allow
remote connections, the same way as this is normally done with Postgres.
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2013-07-31 16:02 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-07-23 02:13 Fw: [osdldbt-general] Running DBT5 on remote database server amul sul <sul_amul@yahoo.co.in>
2013-07-25 13:03 ` Samrat Revagade <revagade.samrat@gmail.com>
2013-07-25 13:26 ` sachin kotwal <kotsachin@gmail.com>
2013-07-31 16:02 ` Greg Smith <greg@2ndQuadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox