On Thu, 2021-02-04 at 16:56 +0530, Atul Kumar wrote: > 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. That is to be expected. If you have 300 processes performing I/O and using CPU, your machine will vertainly be overloaded. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
