Your problem screams "IO saturation".
On 2/4/21 12:07 PM, Atul Kumar wrote:
> 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, Ravi Krishna <rkrishna_pg(at)aol(dot)com
> <mailto:rkrishna_pg(at)aol(dot)com>> wrote:
>
> >The CPU and RAM are normal even on 300 jobs ( only 1-4% of consumption)
> >but I don’t understand one thing here that if max_connections is set
> to 700 then
> >why I am not able to connect the db. As the running jobs (300) are
> lesser than
> >half of max_connections.
>
> Please paste the error message
>
--
Angular momentum makes the world go 'round.