Re: Query regarding PostGre database

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Query regarding PostGre database
Date: 2011-08-18 05:21:32
Message-ID: 4E4CA15C.2040205@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 08/17/11 8:52 PM, Navin Chandra wrote:
> I am an application developer, want to use ‘PostGre’ as backend.

Please note, there is no such thing as PostGre. There is PostgreSQL,
sometimes called Postgres for short.

> May I know what is the maximum possible number of concurrent users?

A better question is, whats the optimal number of concurrent query
operations that can be executed simultaneously to achieve maximum
throughput. Under most conditions, you'll get MORE queries per second
total throughput if you only try and execute between N and 2*N queries
at a time. where N is the number of CPU cores or hardware threads you
have, assuming your storage subsystem has sufficient performance for
your I/O workload.

With connecting pooling, like pg_bouncer, you could have 1000s of
concurrent users on a reasonable sized server, as long as most of them
are idle most of the time. I don't typically allow more than 100 or so
actual connections to a given SQL server if I can avoid it by the use of
pooling.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2011-08-18 05:21:43 Re: Query regarding PostGre database
Previous Message Chris Travers 2011-08-18 04:57:21 Re: Using Postgresql as application server