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

Re: horizontal sharding

From: mobiledreamers(at)gmail(dot)com
To: Scott Marlowe <scott(dot)marlowe(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-27 00:35:23
Message-ID: c1870d60906261735x157e1abdne278f33ab16bb496@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
can someone show how to setup pgpool 2 in parallel *query* mode ie
horizontal partitioningthanks a lot

On Fri, Jun 26, 2009 at 5:35 PM, <mobiledreamers(at)gmail(dot)com> wrote:

> can someone show how to setup pgpool 2 in parallel replication modethanks
> a lot
>
>
> On Thu, Jun 25, 2009 at 10:28 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:
>
>> 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.
>>
>
>
>
> --
> Bidegg worlds best auction site
> http://bidegg.com
>



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

In response to

Responses

pgsql-general by date

Next:From: John R PierceDate: 2009-06-27 00:56:26
Subject: Re: horizontal sharding
Previous:From: mobiledreamersDate: 2009-06-27 00:35:04
Subject: Re: horizontal sharding

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