Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Possible to force queries to abort instead of doing large external sort groupings?

When a GROUP BY hash table can't fit in memory, sometimes the external sort that is triggered is extremely CPU intensive.  If we find it impossible or prohibitively difficult to optimize such queries, is there a way to either force these queries to error out, or limit their CPU usage?

Comments

  • With Vertica 7, you can limit queries on a resource pool to a certain number of cores.  You can also set a RUNTIMECAP, which will cause the query to abort if it runs too long (works pre 7.0).  There isn't currently a way to control the specific case of group by hash spill.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.