| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Selva manickaraja <mavles78(at)gmail(dot)com> |
| Cc: | Greg Smith <greg(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Performance Test for PostgreSQL9 |
| Date: | 2011-03-03 05:20:24 |
| Message-ID: | 1299129624.16115.56.camel@jd-desktop |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Arjen van der Meijden | 2011-03-03 08:15:03 | Re: Anyone tried Flashcache with PostgreSQL? |
| Previous Message | Selva manickaraja | 2011-03-03 05:16:38 | Re: Performance Test for PostgreSQL9 |