projection_storage row_count
+2Hi, I am using database designer query specific to improve performance. After the design and deploy process, in system table projection_storage I find differrent row_count for the projections of the same table. Can you tell me why ? thanks, Pietro
+1Hi! It could be segmentation: who said that number of rows in segmented projection are equal? Same projection over all nodes - but different number of rows on each node (depends on segmentation). Also may be this will be helpful (deleted rows are counted also): http://vertica-forums.com/search.php?st=0&sk=t&sd=d&sr=posts&author_id=92&start=40
+2thank you, Daniel! got it!
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
