Re: Parallel queries for a web-application |performance testing - Mailing list pgsql-performance

From Dimitri Fontaine
Subject Re: Parallel queries for a web-application |performance testing
Date
Msg-id 87aaquqbjm.fsf@hi-media-techno.com
Whole thread Raw
In response to Parallel queries for a web-application |performance testing  (Balkrishna Sharma <b_ki@hotmail.com>)
List pgsql-performance
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-usersinteracting 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

pgsql-performance by date:

Previous
From: "Kaufhold, Christian (LFD)"
Date:
Subject: Query slow after analyse on postgresql 8.2
Next
From: Matthew Wakeling
Date:
Subject: Re: Parallel queries for a web-application |performance testing