Skip to main content

Vertica query performance

  • January 24, 2018
  • 1 reply
  • 8 views
naresh_way2
Forum|alt.badge.img+1

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

    1 reply

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • January 25, 2018

    Hi,

    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;
ALTER DATABASE

    See:
    https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/AdministratorsGuide/ConfiguringTheDB/TupleMoverParameters.htm

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement