Configure system-memory-gb for Presto worker deployment

[coderabbitai]

Description

The Presto worker configuration should include the system-memory-gb property set to approximately 90% of the available machine memory according to the Presto documentation.

Currently, the worker configuration template at tools/deployment/presto-clp/worker/config-template/config.properties does not include this setting, which may lead to suboptimal memory usage.

Suggested Action

Add the system-memory-gb property to the worker configuration template, either:

• As a hardcoded value with documentation explaining how to adjust it
• As an environment variable placeholder for flexible configuration

References

• PR: feat(presto-clp): Add Docker compose setup for Presto cluster that can connect to clp-json. #1132
• Comment: feat(presto-clp): Add Docker compose setup for Presto cluster that can connect to clp-json. #1132 (comment)
• Documentation: https://prestodb.io/docs/current/presto_cpp/properties.html#system-memory-gb

Requested by: @junhaoliao

[junhaoliao]

we may need to configure system-mem-limit-gb and other runtime-dependent parameters from Presto C++ properties
, as their default values don’t automatically adjust to the host environment at startup