On Thursday, February 4, 2021, Ron <ronljohnsonjr@xxxxxxxxx> 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.
