Re: performance of simple query on from-scratch database var
Posted: Fri Mar 21, 2014 9:01 pm
Matthew,
I just wrote
http://www.vertica-forums.com/viewtopic.php?f=63&t=1764
with your question in mind. How to review profiling data for queries that you didn't explicitly profile. This might help you to review the variable performance of these joins.
Another thing to check is how much memory was allocated for the query when it ran each time, and whether it may have "retried" after failing to run on one or more attempts.
--Sharon
I just wrote
http://www.vertica-forums.com/viewtopic.php?f=63&t=1764
with your question in mind. How to review profiling data for queries that you didn't explicitly profile. This might help you to review the variable performance of these joins.
Another thing to check is how much memory was allocated for the query when it ran each time, and whether it may have "retried" after failing to run on one or more attempts.
--Sharon