--- title: "Configuring the autovacuum setting in the lighthouse database using the CLI" slug: "configuring-the-autovacuum-setting-in-the-lighthouse-database-using-the-cli-4" tags: ["Network Security (NX)"] updated: 2026-08-24T22:01:11Z published: 2026-08-24T22:01:11Z canonical: "docs.trellix.com/configuring-the-autovacuum-setting-in-the-lighthouse-database-using-the-cli-4" stale: true --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.trellix.com/llms.txt > Use this file to discover all available pages before exploring further. # Configuring the autovacuum setting in the lighthouse database using the CLI Table bloat in the Lighthouse database can cause performance issues and delays in the Network Security server. The autovacuum helps to constrain table bloat. The `autovacuum_vacuum_scale_factor` is a value that is used to calculate when to perform an autovacuum on the tables in the Lighthouse database. You can change the `autovacuum_vacuum_scale_factor` from the default value of 0.20 to a higher value that will perform the autovacuum less frequently, or a lower value that will perform it more frequently. The optimal frequency depends on the table size, and the duration of the autovacuum on the table. Use the CLI commands in this topic to change the `autovacuum_vacuum_scale_factor` value. You can set the `autovacuum_vacuum_scale_factor` setting to a value between 0.01 and 0.5. The default value is 0.20. Higher values set a less aggressive autovacuum function. Lower values set a more aggressive autovacuum function that can degrade system performance. The recommended value of 0.05 can constrain table bloat while maintaining overall system performance. To set the `autovacuum_vacuum_scale_factor` to the default value of 0.20, enter `DEFAULT` in the value parameter. After you reset the `autovacuum_vacuum_scale_factor` setting, perform a full vacuum on the Lighthouse database. Prerequisites - Administrator access To configure the autovacuum setting in the Lighthouse Database: 1. Go to CLI configuration mode: ``` hostname > enable hostname # configure terminal ``` 2. Shows the current value of the `autovacuum_vacuum_scale_factor`: ``` hostname (config) # show hx server db config autovacuum_vacuum_scale_factor ``` 3. Change the `autovacuum_vacuum_scale_factor` to the recommended value of 0.05: ``` hostname (config) # hx server db config autovacuum_vacuum_scale_factor 0.05 ``` 4. Perform a full vacuum on the Lighthouse database: ``` hostname (config) # hx server db full-vacuum ``` ##### 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 ```