Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 59C626502F5 for ; Mon, 4 Aug 2008 14:46:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 86508-03-8 for ; Mon, 4 Aug 2008 14:46:19 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.31]) by postgresql.org (Postfix) with ESMTP id 069F665028D for ; Mon, 4 Aug 2008 14:46:09 -0300 (ADT) Received: by yw-out-2324.google.com with SMTP id 3so1165907ywj.73 for ; Mon, 04 Aug 2008 10:46:08 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=ZsoYhn3ZkWF9M9jqRJL3wfewScU8k4WVsVF1w7QytnA=; b=M+giFji/fcUXIp6driUcoe877hTZIWDLOeSIx05l1kvOlmrTZkLuE1pn/p3B4Snin5 7ES//iQE6ofN00JnIWviY/HgaJqTdtfq9c4Xnjq+wTGh+H8tdn4FSVG5ou5zWPOQ9i2e dnvhDnZ4q2NJhb4vqGB+eSMIyLIerd3+mKp5g= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=RLC8FRwwwF1Xt71r8fYZd720LV8RL9XFIz9pMV69CaGxqNSX8w3mrtB0aqFe08wwRI 3mjxa2tFNBCpUBit1/QHES93chOx8kGd6IB+trkc//fyNUhXDK00e838+XEb/OQVqSyi Vzy6kGe5gnmJ0SWn2z8BmHkDUDZxaC/ohBKYI= Received: by 10.142.139.19 with SMTP id m19mr5030477wfd.25.1217871967733; Mon, 04 Aug 2008 10:46:07 -0700 (PDT) Received: by 10.142.165.13 with HTTP; Mon, 4 Aug 2008 10:46:07 -0700 (PDT) Message-ID: Date: Mon, 4 Aug 2008 11:46:07 -0600 From: "Scott Marlowe" To: Kesavan Subject: Re: Maximum number of concurrent users Cc: pgsql-admin@postgresql.org, Premshaw In-Reply-To: <489724F7.4060900@emmeskay.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <489724F7.4060900@emmeskay.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/17 X-Sequence-Number: 29862 On Mon, Aug 4, 2008 at 9:49 AM, Kesavan wrote: > Hi > > We are using PostgreSQL 8.3.1 version under windows. > We want to know whether there is any limit on Maximum number of concurrent > users. > In specific, can Postgres handle 1000 concurrent queries? Sure. Give it enough hardware, and it can handle 1,000 concurrent select field from table where pkey = 2345 type queries pretty well. I wouldn't try to run 1,000 reporting queries hitting four tables with 1B to 1G to 1Tera rows or anything. > Regarding our Data size, > > We have 40 tables and in total we have 2GB data. > We are using normal Pentium Quad core processor, 3GHZ system with 2GB RAM as > Database Server. Well, since we have no idea what your usage pattern will be, this question is a little bit like "how many angels can dance on the head of a pin?" i would put more memory in your server so it can fit in memory easily. 4Gig should be enough. 8Gig would be more than enough. But if you're running transactions. you're gonna have to tell us what kind of drive subsystem you have, cause one drive won't handle it. Note that in transactional work, number of drives and their configuration are probably more important than anything else.