The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Create tables partition

Sophie_bdSophie_bd Community Edition User

I have searched for some ways to optimize request-response.
After creating Projection I think to create Partition on my FACT tables, on one functional column that contains data it can be partitioned.
My configuration is one database on 3 nodes.

Best regards,


  • Jim_KnicelyJim_Knicely - Select Field - Administrator
    edited December 2021

    @Sophie_bd - Is there a question in your post? :) Are you asking why a column can't be partitioned?

    If so, read through the "Partitioning Requirements and Restrictions" section of the doc here: Partition Clause.

    If you have any questions, let us know!

Leave a Comment

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