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.
