How do I increase the database cache?

Category: Optimization

The settings for the database cache are located within the file “postgresql.conf” in the “<installdir>dbdata” directory. Open the file with an editor and search for the setting “shared_buffers”. Increase the value from 128MB for instance to 512MB (see screenshot below).

Restart the “JDisc Discovery Database” service in order to refresh the settings.

DatabaseCache DatabaseCache DatabaseCache