473,554 Members | 2,925 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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("por t=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($dbcon n);
?>

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
2 2062
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

Thanks to all for providing information about concurent testing.

Regs,
Durai.

----- Original Message -----
From: "Alvaro Herrera" <al******@dcc.u chile.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*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
2346
by: Pablo | last post by:
At my current job I've been tasked with maintaining a very old C++ application written largely in ANSI c++ in what I believe to be with an old DOS based Borland compiler. I'm trying to add a simple event logging component to the application. Initially I began with a simple: fstream dumpfile dumpfile.open(fname,std::ios_base::out |...
1
1199
by: Marc G. Fournier | last post by:
On Oct 3rd, we released beta4 in the hopes that it would be the final beta before going into the "Release" phase of development ... due to several bug fixes over the past 3 weeks, we've decided to release a Beta5 in order to flesh out any bugs that may have been introduced ... Beta5 contains several fixes that require an initdb from Beta4,...
0
430
by: Durai | last post by:
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:
11
5420
by: Durai | last post by:
Hi All, I tested "concurrent testing" in MySQL. It works fine. But I couldn't do in PostgreSQL 7.3.4 on HPUX IPF. I got deadlock problem. I used the PHP script to update table( one script increment the column & another one decrement the column). Is the postgres support the concurrent access to update database? I got the following errors: ...
11
2306
by: greg | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 A new version of DBD::Pg is about to be released (1.32), and we need your help to test it out. If you use DBD::Pg, please download and test the latest release candidate. At the very least, running "make test" and reporting any problems would be of great help. The latest version can be found...
2
1326
by: David Garamond | last post by:
All of my non-superusers are restricted from creating databases. Whenever I upgrade Postgres, I have to hand-edit my dump and change: CREATE USER usr1 WITH SYSID 101 PASSWORD '...' NOCREATEDB NOCREATEUSER; into: CREATE USER usr1 WITH SYSID 101 PASSWORD '...' CREATEDB NOCREATEUSER; and then after the restore, I do a:
0
1713
by: s | last post by:
I need to develop a multiuser database application to be used by four people(The number of users are not likely to increase). It is for storing records of different versions of particular papers. I am new to building such an application. I would like to know what would the requirements be for using Access as the means for building the...
1
2178
by: flashadow | last post by:
Who can explain. Can JsUnit test dynamic pages? A site uses Apache Tomcat for the start. A site consists of starting page in which is loaded 4 jsp pages. Functions that need testing take information from a page and after processing return data to page using jQuery. And also need testing object which in a constructor has methods which also...
0
2850
by: raamay | last post by:
I am new to VB.Net but since i have a good experience in VB6(having developed 2 to 3 desktop applications), i find no problem coping with the new environment at this stage. Well, i am planning to learn VB.Net and want to kickoff with development of a database application which is multiuser in nature. But as of now, i have not developed...
0
7573
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7778
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8008
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7527
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6114
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5412
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5135
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3525
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1109
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.