Hi, I have 160 GB of RAM, postgres 9.6 is running on the server.
after upgrade I ran the below command: "/usr/edb/as9.6/bin/vacuumdb" -U 'enterprisedb' --verbose --all -j 300 --analyze-only after running that command I was not able to connect the database using psql for few minutes. After 20-30 minutes i was able to connect to the db and at that time I checked the pg_stst_activity, the active connections was reduced to 27. my max_connections is set to 700. I tried to find out the reason for not being abled to connect the db (when 300 jobs were running) but still not got the answer. So suggestions are welcome.
