Does Vertica run analyze_statistics at the Materialize step in EXPLAIN?
Thanks for your help!
Search found 25 matches
- Wed Jan 27, 2016 11:44 pm
- Forum: Vertica Performance Tuning
- Topic: analyze_statistics on "Materialize" Step
- Replies: 5
- Views: 21904
- Tue Nov 10, 2015 11:22 pm
- Forum: Vertica Backup & Recovery
- Topic: apportioned/multi-threaded loads and compressed files
- Replies: 2
- Views: 21151
Re: apportioned/multi-threaded loads and compressed files
Thanks Norbert. Perfect!
- Tue Nov 10, 2015 1:19 am
- Forum: Vertica Backup & Recovery
- Topic: apportioned/multi-threaded loads and compressed files
- Replies: 2
- Views: 21151
apportioned/multi-threaded loads and compressed files
Hello, My questions are about apportioned loads, multi-threaded loads, and compressed files. 1) Apportioned load support & multi-threaded loads - are they different terms for the same thing? 2) Are apportioned/multi-threaded loads disabled when loading compressed files? 3) Does ON ANY NODE invoke ap...
- Mon Aug 24, 2015 7:32 pm
- Forum: Vertica Performance Tuning
- Topic: projection stats not getting updated
- Replies: 9
- Views: 34380
Re: projection stats not getting updated
select version();
Vertica Analytic Database v7.1.2-1
I repeated your test and got the same results you did.
I am looking into this further and will let you know the results.
Vertica Analytic Database v7.1.2-1
I repeated your test and got the same results you did.
I am looking into this further and will let you know the results.
- Mon Aug 24, 2015 3:41 pm
- Forum: Vertica Performance Tuning
- Topic: projection stats not getting updated
- Replies: 9
- Views: 34380
Re: projection stats not getting updated
Thanks very much for your help, Jim & Norbert. Here is the setup, step-by-step. At the bottom of the post, I included what I thought are relevant columns from the projections table - let me know if you need anything else. One thing I noticed - table (superprojection) segmentation and custom projecti...
- Fri Aug 21, 2015 9:21 pm
- Forum: Vertica Performance Tuning
- Topic: projection stats not getting updated
- Replies: 9
- Views: 34380
Re: projection stats not getting updated
Made sure the that refresh was finished. Then ran analyze_statistics. Where create_type (in the projections table) is "CREATE_PROJECTION" has_statistics = false. Where it is "CREATE_TABLE" has_statistics is true. K-safety = 1, all nodes for these projections are populated with data. I am able to rep...
- Fri Aug 21, 2015 7:38 pm
- Forum: Vertica Performance Tuning
- Topic: projection stats not getting updated
- Replies: 9
- Views: 34380
Re: projection stats not getting updated
Good point. I should have mentioned that the table has data.
Also, I ran start_refresh and then queried the projection_storage table to confirm that the projection has data.
Using Amazon AMI 7.1.2-1
Also, I ran start_refresh and then queried the projection_storage table to confirm that the projection has data.
Using Amazon AMI 7.1.2-1