After loading a table with significant volume >50 % the recommendation as per vertica manuals is to run analyze_statistics which take 10 pct sample. Is this enough or should we run analyze_histogram. What should be ideal sample percent (1-100) ? Also does vertica automatically run analyze_statistics after purge /delete or on any other trigger?
analyze_histogram
+2+2when running analyze_histogram on table with millions of rows getting error "Analyze Statistics operation is already in progress on projection" .Did vertica trigger analyze_statistics after the table was purged which caused issue when we executed analyze_histogram ?
Pretty sure the only way analyze_statistics gets run is if YOU run it. Not sure what that message you're getting is.
ANALYZE_STATISTICS is an alias of the function ANALYZE_HISTOGRAM, which is no longer documented.
Some customers use daily partition, because they don't delete data to avoid delete vectors. They do ETL work in staging and then swap partition.
Analyze_histogram might take long time to complete if there are many columns and many partitions. Analyze stats runs faster on fewer partitions because of fewer files, fewer FS interactions etc. (See Jira VER-54532)
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
