setMaxMemory(mb)

Sets the maximum memory usage cap (in megabytes) for the nzLua UDX. The value can be between 1MB and 512MB; the default memory cap is 32MB. The setMaxMemory function must be called from the initialize() function.

Excessive memory usage by a UDX can severely disrupt performance of the Netezza system during high concurrency workloads. Using more than 128MB may require careful job scheduling in some environments to avoid thrashing due to insufficient RAM.

Example

function initialize()
setMaxMemory(128)
end