Tuning for Machine Learning

Scenario

You have a large number of machine learning algorithms running, and you want to improve the performance of the queries. In this scenario, you want to give machine learning functions more memory to improve their performance.

Solution

Vertica executes the machine learning functions in the BLOBDATA resource pool. To improve the performance of the machine learning functions increase the MAXMEMORYSIZE parameter of the BLOBDATA pool. If a query using the BLOBDATA pool exceeds its query planning budget, then it spills to disk.

For more information about tuning your query budget, see Target Memory Determination for Queries in Concurrent Environments.

See Also

• ALTER RESOURCE POOL
• Managing Resources At Query Run Time
• Built-In Pool Configuration
• Built-In Pools