There is no error message, when I try to connect the database while running vacuumdb with 300 jobs, it gets stuck.
On Thursday, February 4, 2021, Ron <ronljohnso...@gmail.com> wrote: > On 2/4/21 5:26 AM, Atul Kumar wrote: > > 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. > > > What's the exact error message? > > 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 > > > Connect to the cluster *before* running "vacuumdb -j300", and start > looking at pg_stst_activity while vacuumdb is running. > > -- > Angular momentum makes the world go 'round. >
