pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Selva manickaraja <mavles78@gmail.com>
Cc: Greg Smith <greg@2ndquadrant.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance Test for PostgreSQL9
Date: Wed, 02 Mar 2011 21:20:24 -0800
Message-ID: <1299129624.16115.56.camel@jd-desktop> (raw)
In-Reply-To: <AANLkTimVPycYKVsfGXtL7-sV5REGbYgUEf+p0uotMqay@mail.gmail.com>
References: <AANLkTi=UEQmkjtkUcgoEbj=zu6DYskyNH5m6qqL79QYp@mail.gmail.com>
	<AANLkTi=RGgtjoQkzwHsPrq1LHV+fb2+rmwyBZX0kT+UB@mail.gmail.com>
	<1299090595.25659.135.camel@jd-desktop>
	<AANLkTi=_T_pXg2+YNNPLyJeAccfebdbtRmUGkin1q2aA@mail.gmail.com>
	<4D6F12A1.5050903@2ndquadrant.com>
	<AANLkTimVPycYKVsfGXtL7-sV5REGbYgUEf+p0uotMqay@mail.gmail.com>

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




view thread (16+ messages)

Message-ID: <1299129624.16115.56.camel@jd-desktop>
Permalink:  ../1299129624.16115.56.camel@jd-desktop/
Also on:    postgresql.org/message-id/1299129624.16115.56.camel@jd-desktop

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jd@commandprompt.com, mavles78@gmail.com, greg@2ndquadrant.com, robertmhaas@gmail.com
  Subject: Re: Performance Test for PostgreSQL9
  In-Reply-To: <1299129624.16115.56.camel@jd-desktop>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox