Re: [Postgres-xc-general] max Coordinators

[Ashutosh B. <ash...@en...>]

We have previously experimented with 10 coordinators and 10 datanodes. That
configuration gave 6 times scalability wrt single PG server. There are
reports in these archives of users trying with 20 servers. So, may be 16
coord + 16 datanodes should not be a problem. But adding coordinators
increases performance if there are enough clients to keep coordinators
busy. They do not store any user data.


On Tue, Sep 17, 2013 at 5:39 PM, Bartłomiej Wójcik <
bar...@tu...> wrote:

>  Hello,
>
> But can I have more then 16 coordinators and 16 datanodes the cluster
> scaling ?
>
> Regards!
>
>
> W dniu 2013-09-17 12:55, Abbas Butt pisze:
>
>  Hi,
>
> Nodes are stored in a table in shared memory, which cannot be resized in
> dynamic fashion. Hence limits are required at startup time to determine
> shared memory size. You can have a cluster with any nodes less than the max
> values defined in the configuration file and then later on add more nodes
> to the cluster until that limit is reached. To add more nodes the
> configuration needs to be changed and the cluster needs to be restarted.
>  Thanks.
>
>
>
> On Tue, Sep 17, 2013 at 3:35 PM, Bartłomiej Wójcik <
> bar...@tu...> wrote:
>
>> Hello,
>>
>> I have a question about default max Coordinators which we can see
>> in the configuration file - postgres.conf and in some presentations
>> about pgxc
>>
>> What happens when you exceed the limit and after crossing?
>>
>> (similar restriction is for nodes)    -    why ?
>>
>> Regards!
>> bw
>>
>>
>>
>> ------------------------------------------------------------------------------
>> LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
>> 1,500+ hours of tutorials including VisualStudio 2012, Windows 8,
>> SharePoint
>> 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack
>> includes
>> Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Postgres-xc-general mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>>
>
>
>
> --
> --
> *Abbas*
>  Architect
>
> Ph: 92.334.5100153
>  Skype ID: gabbasb
>  www.enterprisedb.co <http://www.enterprisedb.com/>m<http://www.enterprisedb.com/>
> *
> Follow us on Twitter*
> @EnterpriseDB
>
> Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community>and more<http://www.enterprisedb.com/resources-community>
>
>
>
>
> ------------------------------------------------------------------------------
> LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
> 1,500+ hours of tutorials including VisualStudio 2012, Windows 8,
> SharePoint
> 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack
> includes
> Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
> http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>


-- 
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company