[Postgres-xl-general] Maximum number of nodes == 16?

Koichi Suzuki koichi.dbms at gmail.com
Thu Sep 24 07:12:36 PDT 2015


Right.   max_datanodes and max_coordintors are GUC parameters you should
set if you need more than 16 datanodes or coordinators.

Regards;

---
Koichi Suzuki
https://www.linkedin.com/in/koichidbms


2015-09-24 23:08 GMT+09:00 Jaimin Pan <jaimin.pan at gmail.com>:

> The patch is not correct method, you should set parameter in postgres.conf
> instead.
>
> 2015-09-23 22:35 GMT+08:00 Tobias Oberstein <tobias.oberstein at gmail.com>:
>
>> Hello,
>>
>> we're evaluating PG-XL on a box with 48 cores, and I am currently
>> failing to run a cluster with 32 nodes.
>>
>> I am using the PG-XL 9.5 alpha1 from here
>> http://www.postgres-xl.org/2015/07/license-change-and-9-5-merge/
>>
>> With 4 and 8 nodes, everything is fine.
>>
>> With 16 nodes, I get the following error when creating the cluster
>>
>> "Too many datanodes, current value of max_data_nodes is 16"
>>
>> I fixed this by patching the sources (see at the end).
>>
>> After that, I rebuilt PG-XL, and I could create and use the cluster.
>>
>> However, with 32 nodes, I now get the following error:
>>
>> """
>> WARNING:  unexpected EOF on datanode connection
>> ERROR:  Failed to receive more data from data node 16384
>> ********** Fehler **********
>>
>> ERROR: Failed to receive more data from data node 16384
>> SQL Status:XX000
>> """
>>
>> What is the maximum number of nodes supported?
>>
>> Thanks!
>> /Tobias
>>
>>
>> PATCH:
>>
>> oberstet at bvr-sql18:~/scm/3rdparty/postgres-xl$ git remote -v
>> origin  http://git.postgresql.org/git/postgres-xl.git (fetch)
>> origin  http://git.postgresql.org/git/postgres-xl.git (push)
>> oberstet at bvr-sql18:~/scm/3rdparty/postgres-xl$ git rev-parse HEAD
>> 27eb886ef2eae4b1392d52f718b9d1f16141daf8
>> oberstet at bvr-sql18:~/scm/3rdparty/postgres-xl$ git diff
>> diff --git a/src/backend/pgxc/nodemgr/nodemgr.c
>> b/src/backend/pgxc/nodemgr/nodemgr.c
>> index 7ff9fda..e00b731 100644
>> --- a/src/backend/pgxc/nodemgr/nodemgr.c
>> +++ b/src/backend/pgxc/nodemgr/nodemgr.c
>> @@ -47,7 +47,7 @@ static Datum generate_node_id(const char *node_name);
>>    * cluster restarted.
>>    */
>>   int                            MaxCoords = 16;
>> -int                            MaxDataNodes = 16;
>> +int                            MaxDataNodes = 128;
>>
>>   /* Global number of nodes. Point to a shared memory block */
>>   static int        *shmemNumCoords;
>> oberstet at bvr-sql18:~/scm/3rdparty/postgres-xl$
>>
>>
>> ------------------------------------------------------------------------------
>> Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
>> Get real-time metrics from all of your servers, apps and tools
>> in one place.
>> SourceForge users - Click here to start your Free Trial of Datadog now!
>> http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
>> _______________________________________________
>> Postgres-xl-general mailing list
>> Postgres-xl-general at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/postgres-xl-general
>>
>
>
>
> ------------------------------------------------------------------------------
> Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
> Get real-time metrics from all of your servers, apps and tools
> in one place.
> SourceForge users - Click here to start your Free Trial of Datadog now!
> http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
> _______________________________________________
> Postgres-xl-general mailing list
> Postgres-xl-general at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/postgres-xl-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20150924/faede5aa/attachment.htm>


More information about the postgres-xl-general mailing list