X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2E97E9DC9A2 for ; Fri, 10 Feb 2006 04:22:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25076-07 for ; Fri, 10 Feb 2006 04:22:47 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id A416D9DC8A9 for ; Fri, 10 Feb 2006 04:22:44 -0400 (AST) Received: from ctb-mesg3.saix.net (ctb-mesg3.saix.net [196.25.240.73]) by svr4.postgresql.org (Postfix) with ESMTP id 067705AF1F4 for ; Fri, 10 Feb 2006 08:22:45 +0000 (GMT) Received: from mygus (dsl-146-121-181.telkomadsl.co.za [165.146.121.181]) by ctb-mesg3.saix.net (Postfix) with ESMTP id 4CF9D443F; Fri, 10 Feb 2006 10:22:36 +0200 (SAST) From: "James Dey" To: Subject: Basic Database Performance Date: Fri, 10 Feb 2006 10:22:35 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0033_01C62E2B.EACBBD10" X-Mailer: Microsoft Office Outlook, Build 11.0.6353 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Thread-Index: AcYuGyUzYb4rrFf9T36Oe9u6HTFB+w== Message-Id: <20060210082236.4CF9D443F@ctb-mesg3.saix.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200602/95 X-Sequence-Number: 17081 This is a multi-part message in MIME format. ------=_NextPart_000_0033_01C62E2B.EACBBD10 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi Guys, Apologies if this is a novice queston, but I think it is a performance one nevertheless. We are running a prototype of a system running on PHP/Postgresql on an Intel Xeon 2ghz server, 1GB RAM, 40GB hard drive, as a test bench. The system will be used for tens of thousands of users, and at the moment we are testing on a base of around 400 users concurrently during the day. During the day, the system is incredibly slow to a point where it is unusable. The reason we are testing on such as small server is to test performance under pressure, and my estimation is that spec should handle thousands of users. The server spikes from 5% usage to 95% up and down. The system is a very simple e-learning and management system and has not given us any issues to date, only since we've been testing with more users has it done so. The fact that 400 users doing inserts and queries every few minutes is very concerning, I would like to know if I could be tweaking some config settings. We are running PG 7.4 on a Debian Sarge server, and will be upgrading to pg8.0 on a new server, but have some migration issues (that's for another list!) Any help would be greatly appreciated! All the very best, James Dey tel +27 11 704-1945 cell +27 82 785-5102 fax +27 11 388-8907 mail james@mygus.com myGUS / SLT retains all its intellectual property rights in any information contained in e-mail messages (or any attachments thereto) which relates to the official business of myGUS / SLT or of any of its associates. Such information may be legally privileged, is to be treated as confidential and myGUS / SLT will take legal steps against any unauthorised use. myGUS / SLT does not take any responsibility for, or endorses any information which does not relate to its official business, including personal mail and/or opinions by senders who may or may not be employed by myGUS / SLT. In the event that you receive a message not intended for you, we request that you notify the sender immediately, do not read, disclose or use the content in any way whatsoever and destroy/delete the message immediately. While myGUS / SLT will take reasonable precautions, it cannot ensure that this e-mail will be free of errors, viruses, interception or interference therewith. myGUS / SLT does not, therefore, issue any guarantees or warranties in this regard and cannot be held liable for any loss or damages incurred by the recipient which have been caused by any of the above-mentioned factors. ------=_NextPart_000_0033_01C62E2B.EACBBD10 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi Guys,

 

Apologies if this is a novice queston, but I think it = is a performance one nevertheless. We are running a prototype of a system = running on PHP/Postgresql on an Intel Xeon 2ghz server, 1GB RAM, 40GB hard drive, = as a test bench. The system will be used for tens of thousands of users, and = at the moment we are testing on a base of around 400 users concurrently during = the day.

 

During the day, the system is incredibly slow to a = point where it is unusable. The reason we are testing on such as small server = is to test performance under pressure, and my estimation is that spec should = handle thousands of users.

 

The server spikes from 5% usage to 95% up and down. = The system is a very simple e-learning and management system and has not given us = any issues to date, only since we’ve been testing with more users has = it done so. The fact that 400 users doing inserts and queries every few minutes = is very concerning, I would like to know if I could be tweaking some config = settings.


We are running PG 7.4 on a Debian Sarge server, and will be upgrading to = pg8.0 on a new server, but have some migration issues (that’s for = another list!)


Any help would be greatly appreciated!


All the very best,

 

James = Dey

 =

t= el           = +27 11 = 704-1945

c= ell       &= nbsp;  +27 82 785-5102

f= ax       &= nbsp;   +27 11 388-8907

m= ail        james@mygus.com<= /font>

 <= /span>

myGUS / SLT retains all its = intellectual property rights in any information contained in e-mail messages (or any attachments thereto) which relates to the official business of myGUS / = SLT or of any of its associates. Such information may be legally privileged, is = to be treated as confidential and myGUS / SLT will take legal steps against = any unauthorised use. myGUS / SLT does not take any responsibility for, or = endorses any information which does not relate to its official business, = including personal mail and/or opinions by senders who may or may not be employed = by myGUS / SLT. In the event that you receive a message not intended for = you, we request that you notify the sender immediately, do not read, disclose or = use the content in any way whatsoever and destroy/delete the message = immediately. While myGUS / SLT will take reasonable precautions, it cannot ensure = that this e-mail will be free of errors, viruses, interception or interference = therewith. myGUS / SLT does not, therefore, issue any guarantees or warranties in = this regard and cannot be held liable for any loss or damages incurred by the recipient which have been caused by any of the above-mentioned = factors.

 

------=_NextPart_000_0033_01C62E2B.EACBBD10--