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!

Vertica query performance

I am using vertica for 3 months. At initial, I got the analytics very fast, but as days increases I am getting slower performance in vertica. I found that deleted row count shows the impact on my vertica analytics. So I decided to purge my deleted rows. I can do manually but it not feasible to me. So I want to set a purge policy which should purge my deleted rows when it reached 10% of my table total row count. How do I set configuration parameters? Can anybody explain?
Thanks in advance,


  • Jim_KnicelyJim_Knicely - Select Field - Administrator


    Take a look at the PurgeMergeoutPercent configuration parameter...

    dbadmin=> SELECT parameter_name, current_value, default_value, description FROM configuration_parameters WHERE parameter_name = 'PurgeMergeoutPercent';
        parameter_name    | current_value | default_value |                                       description
     PurgeMergeoutPercent | 20            | 20            | Maximum % of rows that may be deleted before Tuple Mover purges the ROS through mergeout
    (1 row)
    dbadmin=> ALTER DATABASE test SET PurgeMergeoutPercent = 10;


Leave a Comment

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