Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Aggregate projections and partitions

Hi all

 

I'm investigating the adoption of the aggregate projections to improve metrics on data having more or less dimensions, accordingly the dashboard is accessing them.

 

They seems to be the right tool for this case but they also are deprecated in case of updates and deletes.

 

Updates are not a concern, but I would like to ask you about deletes: such data is retained for a given period then dropped using a drop partition call.

 

Is there any affinity between a delete statement and the drop partition that could affect the adoption of the aggregate projections?

 

thank you in advance

Riccardo Pasquini

Comments

  • what do you mean by affinity between delete and drop partition?

  • as far as i know drop partition is better to use compare to delete because drop partition is faster and creates less delete vectors. i will advise you to use drop projection than delete wherever it is possible.

     

    second it will not impact the usage of aggregate projection

  • Thank you

     

    "second it will not impact the usage of aggregate projection"

     

    that's what I was looking for :)

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.