Menu
▾
▴
postgres-xc-general
|
From: Bartłomiej W. <bar...@tu...> - 2013-09-17 10:35:48
|
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 |
|
From: Abbas B. <abb...@en...> - 2013-09-17 10:56:08
|
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> |
|
From: Bartłomiej W. <bar...@tu...> - 2013-09-17 12:09:25
|
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... > <mailto: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... > <mailto: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> |
|
From: Abbas B. <abb...@en...> - 2013-09-17 12:15:36
|
Yes, check the section of the postgresql.conf file with heading DATA NODES AND CONNECTION POOLING and change the parameters max_coordinators and max_datanodes to the values you like. On Tue, Sep 17, 2013 at 5:09 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> > > > -- -- *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> |
|
From: Ashutosh B. <ash...@en...> - 2013-09-17 12:17:19
|
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 |
Thanks for helping keep SourceForge clean.
X