From: Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
To: shyam megha <shyamnguitar@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Concurrent Users
Date: Tue, 27 Aug 2013 08:24:23 +0200
Message-ID: <5f1c3f2e76806530db299c936228031c@2ndquadrant.it> (raw)
In-Reply-To: <CALWKM1QXC-_YAauqCEX82ry9hZCc+XXKRSLF6YTahBzxsO2NcA@mail.gmail.com>
References: <CALWKM1QXC-_YAauqCEX82ry9hZCc+XXKRSLF6YTahBzxsO2NcA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Gabriele.Bartolini@2ndQuadrant.it, shyamnguitar@gmail.com
Subject: Re: Concurrent Users
In-Reply-To: <5f1c3f2e76806530db299c936228031c@2ndquadrant.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox