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

From: sachin kotwal <kotsachin(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Fw: [osdldbt-general] Running DBT5 on remote database server
Date: 2013-07-25 13:26:18
Message-ID: 1374758778659-5765132.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

It is always better to run performance script and database on different
machines.

From DBT5 documentation it doesn't seems like you can connect to remote
host.
If yo found you can use that.

If it is not present then:-

Use wrapper tools like pg_bench tool which samrat has suggested .

where you can specify dbt5 command as in this tool command for pg_bench is
written.

Also check host variable in dbt5 and if it is possible to change values for
that variable then pass address of remote host.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Fw-osdldbt-general-Running-DBT5-on-remote-database-server-tp5764754p5765132.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2013-07-25 13:41:42 Re: How is memory allocated/used by Postgresql Database connections
Previous Message McKinzie, Alan (Alan) 2013-07-25 13:23:46 How is memory allocated/used by Postgresql Database connections