From: | "Durai" <visolve_postgres(at)lycos(dot)co(dot)uk> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Multiuser testing -- PostgreSQL 7.3.4 |
Date: | 2003-11-20 16:03:48 |
Message-ID: | 0a1501c3af7f$e6b22d90$1a0110ac@dumco |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Seum-Lim Gan | 2003-11-20 16:07:03 | pg_hba.conf change in 7.4 |
Previous Message | konf | 2003-11-20 15:51:37 | error durring compilation |