The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Why some queries exceed time cap set?
We set parameter to limit execution time for queries to 30 seconds. In error_messages we can observe, that it works - message "Execution time exceeded run time cap of 00:00:30". But measuring execution time for queries shows that some of them exceed this given time. Some queries can last even few minutes. Why it is like this? How to limit it permanently?