By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,773 Members | 1,710 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,773 IT Pros & Developers. It's quick & easy.

Multiuser testing -- PostgreSQL 7.3.4

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a

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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.