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
Date: Thu, 17 Jun 2010 10:59:57 +0200
Message-ID: <87aaquqbjm.fsf@hi-media-techno.com> (raw)
In-Reply-To: <BAY149-w5365651952D598741FE4E1F0DE0@phx.gbl>
References: <BAY149-w5365651952D598741FE4E1F0DE0@phx.gbl>
Balkrishna Sharma <b_ki@hotmail.com> writes:
> I will have a web application having postgres 8.4+ as backend. At any given 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 : 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,
--
dim
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: dfontaine@hi-media.com, b_ki@hotmail.com
Subject: Re: Parallel queries for a web-application |performance testing
In-Reply-To: <87aaquqbjm.fsf@hi-media-techno.com>
* 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