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

tuning recomendation

On Vertica 7.1.1 I have this tuning recomendation:

 

MaxDumpsOnInternalError

reset configuration parameter with set_config_parameter() select

 

set_config_parameter('MaxDumpsOnInternalError', '<new_value>')

 

But this paramewter does not exists 

 

SELECT * FROM CONFIGURATION_PARAMETERS where parameter_name = 'MaxDumpsOnInternalError'

Comments

  • Massimo,

     

    Hewlett Packard does not recommend using the MaxDumpsOnInternalError configuration parameter in a production environment.

     

    If the value changed somehow, as of 7.1.1, you can reset that parameter using the following command:

     

    => ALTER DATABASE <db_name> CLEAR MaxDumpsOnInternalError;

     

    I hope that helps,

     

    Sarah

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.