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
performance of simple query on from-scratch database varies
Moderator: NorbertKrupa
Re: performance of simple query on from-scratch database var
Sharon Cutter
Vertica Consultant, Zazz Technologies LLC
Vertica Consultant, Zazz Technologies LLC
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: performance of simple query on from-scratch database var
I'm very curious about what you mean by prime the caches. While there is some metadata collected, the queries should be freshly compiled each run.
Checkout vertica.tips for more Vertica resources.
Re: performance of simple query on from-scratch database var
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Wed May 06, 2015 5:52 pm, edited 1 time in total.
Re: performance of simple query on from-scratch database varies
Hi,
I thought Formatted query without noise and with table aliases for better readability access: locking differs from dropping and recreating indexes from scratch in ... does not copy existing statistics over to the new version of the DB.
I thought Formatted query without noise and with table aliases for better readability access: locking differs from dropping and recreating indexes from scratch in ... does not copy existing statistics over to the new version of the DB.