Database autotuningΒΆ

The Plixer Endpoint Analytics database is automatically tuned to suit available system resources during the initial installation process.

The autotuning script can also be run manually when and as needed via CLI.

To run the script, open an SSH session to the appliance and change directory to /usr/beacon/scripts/maint.

From there, run the following script:

./db_config_manager

The database autotuning script has the following settings that can be changed:

Setting

Description

Flag

Auto

Adjusts postgresql.conf automatically based on hardware

-a

Reset

Resets postgresql.conf to factory default

-r

Size

Deploys preconfigured postgresql.conf based on standard database sizing

-s (S|M|L)

Help

Displays command help

-h