On Thu, 2011-03-03 at 13:16 +0800, Selva manickaraja wrote:
> Thanks for the enlightenment. I will then look into other tools that
> help
> with performance testing. Is pgbench really useful? We need to produce
> the
> reports and statistics to our management as we are planning to migrate
> one
> system at a time from Informix. This is to ensure that we do not
> overload
> the database with all the systems eventually. So can pgbench help us
> here?
If you have an existing system, you best bet is to migrate your schema
and a data snapshot from that system to PostgreSQL. Then take a portion
of your more expensive queries and port them to PostgreSQL and compare
from there.
A vanilla PgBench or other workload manager will do nothing to help you
with a real world metric to provide to those that wear ties.
JD
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt