projection_storage row_count

Pietro_La_Torre

Hi, 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

Daniel_Leybovic

Hi! 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

Pietro_La_Torre

thank you, Daniel! got it!