Thread: Multiuser testing -- PostgreSQL 7.3.4
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);
?>
$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
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)
Thanks to all for providing information about concurent testing. Regs, Durai. ----- Original Message ----- From: "Alvaro Herrera" <alvherre@dcc.uchile.cl> To: "Durai" <visolve_postgres@lycos.co.uk> Cc: <pgsql-general@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