How to tune your DB (Database)

We highly recommend tuning the database configuration based on the following article before starting using JetPatch.

1. Open the link and fill in all parameters based on your machine settings you've configured in. 
   • DB Version :  Insert version based on your DB.
   • OS Type : Linux
   • DB Type : Web Application
   • Total Memory Size : Insert memory size based on the JetPatch Machine you chose.
   • Number CPU : Insert memory size based on the JetPatch Machine you chose.
   • Storage : HDD Storage
2. Click on 'Generate'
3. Modify the 'Postgres.conf' configuration file based on the recommendations given in the PGTune link. Paste the configuration at the bottom of the file. The configuration file path is /var/lib/pgsql/[version#]/data/postgresql.conf
4. Restart DB service.

Please note: 

1. The settings above refer to a standalone DB machine. If you have chosen the "All-In-One" option. please fill in the following
   1. Micro: Memory 8, CPU 4
   2. Small: Memory 16, CPU 8
   3. Medium: Memory 32, CPU 16
2. If the configuration is not located in the default location run the following to locate it: 

sudo updatedb

locate postgresql.conf