tuning recomendation

+1

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'

+2

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

Sign up