Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 25C5F64FD2F for ; Mon, 4 Aug 2008 12:57:52 -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 87803-09 for ; Mon, 4 Aug 2008 12:57:49 -0300 (ADT) X-Greylist: delayed 00:17:00.21782 by SQLgrey-1.7.6 Received: from master.emmeskay.com (master.emmeskay.com [65.49.60.102]) by postgresql.org (Postfix) with ESMTP id 7A5B364FD13 for ; Mon, 4 Aug 2008 12:57:49 -0300 (ADT) Received: by master.emmeskay.com (Postfix, from userid 50000) id 8E97D14BBC; Mon, 4 Aug 2008 11:40:47 -0400 (EDT) Received: from master.emmeskay.com (master.emmeskay.com [127.0.0.1]) by master.emmeskay.com (Postfix) with ESMTP id 9F73214BB1; Mon, 4 Aug 2008 11:40:46 -0400 (EDT) Received: from [192.168.1.135] (unknown [61.17.188.50]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by master.emmeskay.com (Postfix) with ESMTP id D0BF414B6F; Mon, 4 Aug 2008 11:40:45 -0400 (EDT) Message-ID: <489724F7.4060900@emmeskay.com> Date: Mon, 04 Aug 2008 21:19:11 +0530 From: Kesavan User-Agent: Thunderbird 2.0.0.16 (Windows/20080708) MIME-Version: 1.0 To: pgsql-admin@postgresql.org CC: Premshaw Subject: Maximum number of concurrent users X-Enigmail-Version: 0.95.6 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV using ClamSMTP 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/15 X-Sequence-Number: 29860 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? 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. Kindly provide your inputs. Thanks in advance S.Kesavan Emmeskay Systems, Chennai, India.