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 <
ronljohnsonjr@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.