memory_manager_low_watermark_mb (integer)

• Default value (as of this release): 80 GB
• Cloud default: Set to 80% of available system memory during installation.

Defines the target memory level the system aims for once cancellation begins.

After total frontend memory usage exceeds memory_manager_high_watermark_mb, the Frontend Memory Manager cancels queries until overall memory drops below this lower limit.

Keeping a gap of at least 30% between the high and low watermarks prevents rapid oscillation between cancel and resume states.