This tool calculates recommended memory limits for WarehousePG environments. It is designed to maximize database memory utilization while maintaining a conservative buffer for Linux kernel operations, ensuring system stability even under high concurrency or heavy workloads.

Choose the value for Primary Segments Per Node based on your mirroring strategy.

See Overview of Segment Mirroring for more information on group and spread mirroring strategies.

• Given a configuration of 6 primaries and 6 mirrors, set Primary Segments Per Node to 6+6=12 when using group mirroring.
• Using the same configuration example for spread mirroring, the value would be 6+2=8.

For more information on memory, please refer to the WarehousePG Memory Overview.