Search Postgresql Archives

Re: horizontal sharding

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



can someone show how to setup pgpool 2 in parallel query mode ie horizontal partitioning
thanks a lot

On Fri, Jun 26, 2009 at 5:35 PM, <mobiledreamers@xxxxxxxxx> wrote:
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@xxxxxxxxx> wrote:
On Thu, Jun 25, 2009 at 12:03 AM, <mobiledreamers@xxxxxxxxx> 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



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux