We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


tuning recomendation — Vertica Forum

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