Multiuser testing -- PostgreSQL 7.3.4

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

Responses

Browse pgsql-general by date

  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