[PERFORM] DBT-1

2012-11-04 Thread Samrat
where should i get the original working source code of DBT-1 bechmark and it
is compatible with postgres 9.2?



--
View this message in context: 
http://postgresql.1045698.n5.nabble.com/DBT-1-tp5730629.html
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


[PERFORM] DBT-1

2012-11-04 Thread Revagade, Samrat

where should i get the original working source code of DBT-1 benchmark and it 
is compatible with postgres 9.2?

Best Regards

[Description: a]
Samrat Revagade |Software Engineer | NTTDATA Global Technology Services Pvt. 
Ltd.|
samrat.revag...@nttdata.com<mailto:samrat.revag...@nttdata.com> | Work- 
+91-20-66041500 x 626 | Mob - +91 9665572989
[Description: Description: nttd]



__
Disclaimer:This email and any attachments are sent in strictest confidence for 
the sole use of the addressee and may contain legally privileged, confidential, 
and proprietary data.  If you are not the intended recipient, please advise the 
sender by replying promptly to this email and then delete and destroy this 
email and any attachments without any further use, copying or forwarding<><>

Re: [PERFORM] Fw: [osdldbt-general] Running DBT5 on remote database server

2013-07-25 Thread Samrat Revagade
>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-tp5764754p5765128.html
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