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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
