X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4316AD1BB91 for ; Thu, 11 Dec 2003 14:55:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 51326-01 for ; Thu, 11 Dec 2003 10:55:03 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 6A8E8D1C4E2 for ; Thu, 11 Dec 2003 10:54:43 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id hBBEsH19013179; Thu, 11 Dec 2003 09:54:18 -0500 (EST) To: Alfranio Correia Junior Cc: pgsql-performance@postgresql.org Subject: Re: Performance problems with a higher number of clients In-reply-to: <3FD7EEE8.4080904@lsd.di.uminho.pt> References: <3FD7EEE8.4080904@lsd.di.uminho.pt> Comments: In-reply-to Alfranio Correia Junior message dated "Thu, 11 Dec 2003 04:13:28 +0000" Date: Thu, 11 Dec 2003 09:54:17 -0500 Message-ID: <13178.1071154457@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/178 X-Sequence-Number: 5038 Alfranio Correia Junior writes: > I am facing a problem trying to put 500 concurrent users accessing > a postgresql instance. I think you're going to need to buy more RAM. 1Gb of RAM means there is a maximum of 2Mb available per Postgres process before you start to go into swap hell --- in practice a lot less, since you have to allow for other things like the kernel and other applications. AFAIR TPC-C doesn't involve any complex queries, so it's possible you could run it with only 1Mb of workspace per process, but not when you've configured > sort_mem = 10240 That's ten times more than your configuration can possibly support. (I don't recall whether TPC-C uses any queries that would sort, so it's possible this setting isn't affecting you; but if you are doing any sorts then it's killing you.) Bottom line is you probably need more RAM. regards, tom lane