[Postgres-xl-general] PgXL Scaling

Petr Chmelar petr.chmelar at greycortex.com
Fri Sep 9 03:23:58 PDT 2016


Hi As,

thank you for the confirmation that it works fine on 16 nodes, this is 
important for us.

I agree with your remark that we should carefully plan the size of the 
cluster. However we don't have enough information to do this at the 
moment. So we'll have to perform the tests. Do you think some cloud 
service would be accurate enough to accomplish the tests, please?

Thanks a lot,

Petr


On 9.9.2016 11:48, asvany wrote:
>
> Hi Petr,
>
> I use a cluster with 8 hw nodes with 1 coordinator and 16 datanodes ( 
> 2 datanode on each hw node )
>
> I am satisfied about the performance of the system.
>
> Resizing of the the cluster with adding new nodes is possible but it 
> can be a slow process.
>
> I think to better if you plan carefully the initial size of the cluster.
>
> Cheers,
>
> As
>
>
> On 09/07/2016 11:48 PM, Petr Chmelar wrote:
>>
>> Hi there,
>>
>> I read the comments at Quora 
>> https://www.quora.com/Is-Postgres-XL-production-ready-What-are-some-stories 
>> and Bill West states there:
>>
>> "I believe that Postgres-XL is about as production ready as possible 
>> for the nature of the product it is. ...
>>
>> It is also best to consider using deletes and updates as sparingly as 
>> possible since they create a lot of overhead trying to maintain data 
>> integrity among the nodes. ...
>>
>> The price you pay for having such a large slice of the standard SQL 
>> library is that performance begins to degrade after adding very few 
>> nodes to the database. I believe it begins to tail off at an 
>> increasing rate after 4 nodes. So if you have a project which will 
>> require dozens or hundreds of nodes, this is probably not the product 
>> for you."
>>
>> Do you have any experience?
>>
>> Or, is out there any better comment?
>>
>> If not, should we perform the tests ourselves? Since we don't have 
>> many free HW appliances, can we use some virtual HW or cloud 
>> services, even if they don't guarantee the quality of IO (IOps, R/W Bps)?
>>
>> Cheers,
>>
>> Petr
>>
>>
>>
>> ------------------------------------------------------------------------------
>>
>>
>> _______________________________________________
>> Postgres-xl-general mailing list
>> Postgres-xl-general at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/postgres-xl-general
>
>
>
> ------------------------------------------------------------------------------
>
>
> _______________________________________________
> 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/20160909/483cba90/attachment.htm>


More information about the postgres-xl-general mailing list