Postgres Pro
Downloads
Home   >   mailing lists

Re: horizontal sharding - Mailing list pgsql-general

From mobiledreamers@gmail.com
Subject Re: horizontal sharding
Date
Msg-id c1870d60906261735k6472e801q5bfcb105e2e72e42@mail.gmail.com
Whole thread Raw
In response to Re: horizontal sharding  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: horizontal sharding  (mobiledreamers@gmail.com)
List pgsql-general
Tree view
can someone show how to setup pgpool 2 in parallel replication mode
thanks a lot

On Thu, Jun 25, 2009 at 10:28 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
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.



--
Bidegg worlds best auction site
http://bidegg.com

pgsql-general by date:

Previous
From: Gerry Reno
Date:
Subject: Re: Replication
Next
From: mobiledreamers@gmail.com
Date:
Subject: Re: horizontal sharding