Re: horizontal sharding

Scott Marlowe <scott.marlowe@gmail.com>

From: Scott Marlowe <scott.marlowe@gmail.com>
To: mobiledreamers@gmail.com
Cc: David Fetter <david@fetter.org>, pgsql-general@postgresql.org
Date: 2009-06-25T17:28:55Z
Lists: pgsql-general
On Thu, Jun 25, 2009 at 12:03 AM, <mobiledreamers@gmail.com> wrote:
> GOals are to scale our game for 10000 simultaneous connection to db
> right now db crashing at 500 or 1000 sim connections

Definitely look into pooling.  I've got a pretty hefty database server
(16 15k5 drives, HW RAID, 32Gig RAM and 8 cores) and I wouldn't DREAM
of trying to handle 10,000 simo connections with it.