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:



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'


  • 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,



Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
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.