Skip site navigation (1) Skip section navigation (2)

Looking for installations with a large number of concurrent users

From: David Kerr <dmk(at)mr-paradox(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Looking for installations with a large number of concurrent users
Date: 2009-06-09 23:12:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Hello all,

We're implementing a fairly large J2EE application, I'm estimating around 
450,000 concurrent users at high peak. Performing reads and writes and
we have a very high performance requirement.

I'll be using connection pooling (probably the pooling delivered with 

I'd like to get an idea of "how big can I go". without running into context
switch storms, or hiting some other wall. 

The design actually calls for multiple databases but I'm trying to get a 
good idea of the max size / database. (I.e., don't want 50+ database servers 
if i can avoid it)

We'll be on 8.4 (or 8.5) by the time we go live and SLES linux (for now).
I don't have hardware yet, basically, we'll purchase enough hardware to
handle whatever we need... 

Is anyone willing to share their max connections and maybe some rough 
hardware sizing (cpu/mem?).




pgsql-performance by date

Next:From: Laszlo NagyDate: 2009-06-10 09:10:28
Subject: Re: Why is my stats collector so busy?
Previous:From: Tom LaneDate: 2009-06-09 16:42:56
Subject: Re: Problems with autovacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group