Configures the value of the specified setting in the server Lighthouse database.
Syntax
hx server db config <setting name> <value>
Parameters
setting name
The database setting that is to be configured. The command currently supports one setting, autovacuum_vacuum_scale_factor. Change the autovacuum_vacuum_scale_factor value to reduce table bloat in the database that can cause performance issues and delays in the server. Higher values set a less aggressive autovacuum function. Lower values set a more aggressive autovacuum function that can degrade system performance. After you reset the autovacuum_vacuum_scale_factor setting, perform a full vacuum on the server Lighthouse database.
value
The value of the specified setting. You can set the autovacuum_vacuum_scale_factor setting to a value between 0.01 and 0.5. The recommended value of 0.05 can prevent the database becoming overloaded with data, without significantly impacting system performance. To set the autovacuum_vacuum_scale_factor to the default value of 0.20, enter DEFAULT in the value parameter.
Example
The following example changes the value of the autovacuum_vacuum_scale_factor setting to 0.05.
hostname (config) # hx server db config autovacuum_vacuum_scale_factor 0.05
Current value: autovacuum_vacuum_scale_factor = 0.2
alter system set autovacuum_vacuum_scale_factor = 0.05
ALTER SYSTEM
select pg_reload_conf()
t
New value: autovacuum_vacuum_scale_factor = 0.05
User role
Admin
Command mode
Config
Supported appliances
This command is supported on the following appliances running the specified releases or later:
Endpoint Security (HX): Release 5.1.0