MIME-Version: 1.0
Content-Type: text/plain;
 charset=UTF-8;
 format=flowed
Content-Transfer-Encoding: 8bit
Date: Tue, 27 Aug 2013 08:24:23 +0200
From: Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
To: shyam megha <shyamnguitar@gmail.com>
Cc: <pgsql-admin@postgresql.org>
Subject: Re: Concurrent Users
In-Reply-To: 
 <CALWKM1QXC-_YAauqCEX82ry9hZCc+XXKRSLF6YTahBzxsO2NcA@mail.gmail.com>
References: 
 <CALWKM1QXC-_YAauqCEX82ry9hZCc+XXKRSLF6YTahBzxsO2NcA@mail.gmail.com>
Message-ID: <5f1c3f2e76806530db299c936228031c@2ndquadrant.it>
User-Agent: [X]con Webmail/0.4.2
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

 Hi,

 On Tue, 27 Aug 2013 11:35:51 +0530, shyam megha 
 <shyamnguitar@gmail.com> wrote:
> 1. WHAT IS THE NUMBER OF CONCURRENT USERS WHO CAN ACCESS THE
> POSTGRESQL 9.X SERVER AT A TIME? IS IT NECESSARY FOR ME TO GO FOR
> POSTGRES ADVANCED SERVER PLUS OR ANY OTHER ADVANCED EDITION 

 It all depends on their access patterns. Indeed, it is very easy to 
 write queries that put down every database on earth. ;)

 However, we normally work with vanilla PostgreSQL (the community 
 maintained project) and manage large numbers of concurrent users and 
 queries. My suggestion is for you to methodically work on a benchmark 
 and then evaluate different hardware setups. It takes time and money, 
 but gives you enough insights on your hardware requirements and 
 performance. Also, vertical scalability with Postgres has done giant 
 leaps in the last years.

> In our company we are looking for concurrent access of geospatial
> data by 100 users at a time.

 Again, this could lead to a "Yes, Postgres can" as well as "No, 
 Postgres can't" answer, depending on the nature of your queries.

> 2. ALSO IS THERE MAXIMUM STORAGE VALUE THAT POSTGRES SUPPORTS? WE ARE
> PLANNING TO WORK WITH TERABYTES OF DATA.

 Postgres does not have a theoretical limit in storage. However, when 
 managing terabytes, you need to take some precautions - as any DBMS.

 However, a positive message: we normally work with multi-terabyte 
 databases, with also leading applications/clients in the GIS industry, 
 and Postgres does its job extremely well. ;)

 Cheers,
 Gabriele
-- 
  Gabriele Bartolini - 2ndQuadrant Italia
  PostgreSQL Training, Services and Support
  Gabriele.Bartolini@2ndQuadrant.it - www.2ndQuadrant.it


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin