Page 1 of 1

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

Posted: Fri Mar 21, 2014 9:01 pm
by scutter
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

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

Posted: Mon Mar 24, 2014 5:49 pm
by NorbertKrupa
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.

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

Posted: Wed Mar 26, 2014 9:25 pm
by id10t
Hi!

[DELETED]

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

Posted: Tue Jan 22, 2019 11:51 am
by adila10
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.