Monday, April 23, 2018

VACUMM postgress from pgadmin3

To Vacumm postgress follow mention methode.

First, start postgress service.

Connect the postgress of minder server from pgadminIII

Navigate to mention location
- servers
- Minder (IP address of the minder server)
- Databases
+ ipmreportdb

right click on ipmreportdb and select Maintanance
















Now select Vacuum



















It will take time and once it is comleted click on Done
Now ANALYZE the pgsql.






































Now Re-index the pgsql.






































Now Restart the postgress.

No comments:

Post a Comment