performance of simple query on from-scratch database varies

Moderator: NorbertKrupa

Post Reply
scutter
Master
Master
Posts: 302
Joined: Tue Aug 07, 2012 2:15 am

Re: performance of simple query on from-scratch database var

Post by scutter » 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
Sharon Cutter
Vertica Consultant, Zazz Technologies LLC

NorbertKrupa
GURU
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

Post by NorbertKrupa » Mon Mar 24, 2014 5:49 pm

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.

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: performance of simple query on from-scratch database var

Post by id10t » Wed Mar 26, 2014 9:25 pm

Hi!

[DELETED]
Last edited by id10t on Wed May 06, 2015 5:52 pm, edited 1 time in total.

adila10
Newbie
Newbie
Posts: 1
Joined: Tue Jan 22, 2019 11:49 am

Re: performance of simple query on from-scratch database varies

Post by adila10 » Tue Jan 22, 2019 11:51 am

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.

Post Reply

Return to “Vertica Performance Tuning”