Vertica Quick Tip: Tuple Mover (TM) Assigned More Resources in Vertica 9.1

Posted May 24, 2018 by Soniya Shah, Information Developer

Database Server Room
This blog post was authored by Jim Knicely. In version 9.1 and later, Vertica increases the default amount of memory assigned to the Tuple Mover (TM) resource pool from 200MB to 5% of available memory to improve performance merging out wide tables. If your General resource pool is defined by a percentage, the Tuple Mover pool can potentially compete with the General pool for memory. Users running queries in the general pool may notice regressions in memory-sensitive queries. Database administrators can adjust these pools to suit their needs, if you encounter this issue. Have Fun!