Multiuser testing -- PostgreSQL 7.3.4

[Durai]

Hello All,

How to test the "Multiuser testing" in PostgreSQL?. I used the apache bench "ab" tool for this one.

The following command execute the "test.php" 50 times concurrently.

$ ab -c 1 -n 50 http://127.0.0.1/test.php

The test.php file contains the following contents:

<?php
$dbconn = pg_connect("port=5432 dbname=test user=postgres");
$result = pg_exec ($dbconn, "update table1 set C2=C2+C1;");
$result = pg_exec ($dbconn, "update table1 set C2=C2-C1;");
pg_close($dbconn);
?>

Is this the correct way for MULTIUSER testing?

Is any other way available for MULTIUSER testing in PostgreSQL?

Help greately appreciated.

Regs,
Durai.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.538 / Virus Database: 333 - Release Date: 11/10/2003

[Alvaro Herrera]

On Thu, Nov 20, 2003 at 09:33:48PM +0530, Durai wrote:

How to test the "Multiuser testing" in PostgreSQL?. I used
the apache bench "ab" tool for this one.

For a real world test you would need several scripts doing different
things: updates to different rows, insertions, maybe deletes. Set them up to
be reachable from your web server somehow, and then pass the URLs to siege
(http://joedog.org/siege/).

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"The West won the world not by the superiority of its ideas or values
or religion but rather by its superiority in applying organized violence.
Westerners often forget this fact, non-Westerners never do."
(Samuel P. Huntington)

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Durai]

Thanks to all for providing information about concurent testing.

Regs,
Durai.

----- Original Message -----
From: "Alvaro Herrera" <al******@dcc.uchile.cl>
To: "Durai" <vi**************@lycos.co.uk>
Cc: <pg***********@postgresql.org>
Sent: Saturday, November 22, 2003 7:52 PM
Subject: Re: [GENERAL] Multiuser testing -- PostgreSQL 7.3.4

On Thu, Nov 20, 2003 at 09:33:48PM +0530, Durai wrote:

How to test the "Multiuser testing" in PostgreSQL?. I used the apache bench "ab" tool for this one.
For a real world test you would need several scripts doing different
things: updates to different rows, insertions, maybe deletes. Set them up

to be reachable from your web server somehow, and then pass the URLs to siege
(http://joedog.org/siege/).

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"The West won the world not by the superiority of its ideas or values
or religion but rather by its superiority in applying organized violence.
Westerners often forget this fact, non-Westerners never do."
(Samuel P. Huntington)

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.538 / Virus Database: 333 - Release Date: 11/10/2003
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly