Is there a way to optimize the database of on-prem Nexpose Security Console?
We have some recommendations for optimizing database performance here:
One option is to create a
CustomRuntimeEnvironment.env file, which enables you to limit the amount of memory that the Java Virtual Machine uses for the console and free up memory for the database. You just want to be cognizant of existing memory requirements for the console.
Another thing you can do is edit the
postgresql.conf file to tune your settings based on the version of PostgreSQL you’re currently running. The link above walks you through these things in more detail.