Re: horizontal sharding

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: mobiledreamers(at)gmail(dot)com
Cc: David Fetter <david(at)fetter(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: horizontal sharding
Date: 2009-06-25 17:28:55
Message-ID: dcc563d10906251028v3827793dkb00b3ad6b630b924@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jun 25, 2009 at 12:03 AM, <mobiledreamers(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-06-25 17:31:49 Re: Vacuum on the database versus individual tables.
Previous Message johnf 2009-06-25 16:30:02 datestyle no effect in 8.3.7