From: Dimitri Fontaine <dfontaine@hi-media.com>
To: Balkrishna Sharma <b_ki@hotmail.com>
Cc: <pgsql-performance@postgresql.org>
Subject: Re: Parallel queries for a web-application |performance testing
Organization: Hi-Media
References: <BAY149-w5365651952D598741FE4E1F0DE0@phx.gbl>
User-Mail-Address: dfontaine@hi-media.com
Date: Thu, 17 Jun 2010 10:59:57 +0200
In-Reply-To: <BAY149-w5365651952D598741FE4E1F0DE0@phx.gbl> (Balkrishna
	Sharma's message of "Wed, 16 Jun 2010 13:00:22 -0400")
Message-ID: <87aaquqbjm.fsf@hi-media-techno.com>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Balkrishna Sharma <b_ki@hotmail.com> writes:
> I will have a web application having postgres 8.4+ as backend. At any giv=
en time, there will be max of 1000 parallel web-users interacting with the =
database (read/write)
> I wish to do performance testing of 1000 simultaneous read/write to
> the database.

See about tsung, and either benckmarck only the PostgreSQL side of
things, or at the HTTP side of things directly=C2=A0: that will run your
application code against PostgreSQL.

  http://tsung.erlang-projects.org/

And as Kevin said, consider using a connection pool, such as
pgbouncer. Once you have setup the benchmark with Tsung, adding
pgbouncer and comparing the results will be easy.

Regards,
--=20
dim