Thank you for you feedback my postgres is running on 9.1 version and when i checked that autovacuum in my production by command ps -axww | grep autovacuum it says the output as it has some process running with this id so how to solve my problem but in postgress config file it was commented.
My application is an online ERP which is supported by openbravo has an users of about 150(arount 50 active users) with it and could you suggest me the perfect variables to set us in postgres config file.
The system has a RAM of 16 GB and the following variables
Firstly Thank you so much for your valuable information provided, So what should i do for increasing my database performance? and could you suggest me how to continue to the vacuum process and will it decrease my database performance?
If you need further help, you will have to be more specific on what performance problems you are facing, with their explain anaylze output for folks here to help you out.