Setting Memory Properties for a Task
Open Text Corporation recommends that you increase memory allocation to improve performance.
Note: The default buffer size for Informatica PowerCenter is set very conservatively. These settings can cause PowerCenter to send Vertica many small batches, rather than a few large batches. The overhead of these many small batches can cause loading performance issues. To resolve these performance issues, you should change PowerCenter's batch size settings. Your specific settings depend upon your system resources and needs.
Perform the following procedure to increase memory allocation for a task.
- While in Workflow Manager, double-click the task that connects to Vertica.
-
In the Edit Tasks dialog box, under the Mapping tab, select Memory Properties. Considering your task requirements and your system limitations, set the following attributes.
Note: Allocate more memory than mentioned here according to your system limitations and needs. The settings given may not be realistic for the tasks you intend to perform.- Set Default buffer block size to at least 16 MB.
- Set Maximum Memory Allowed for Auto Memory Attributes to at least 512 MB.
-
Set Maximum Percentage of Total Memory Allowed for Auto Memory Attributes to at least 25.