Re: vacuumdb not letting me connect to db
От | Atul Kumar |
---|---|
Тема | Re: vacuumdb not letting me connect to db |
Дата | |
Msg-id | CA+ONtZ5VcPA1s5fuHb6+x4W_Nv9SrFdtDG+H3OKAiSLHgn-7Yw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: vacuumdb not letting me connect to db (Ron <ronljohnsonjr@gmail.com>) |
Ответы |
Re: vacuumdb not letting me connect to db
|
Список | pgsql-general |
ok, How do I resolve it ? Any suggestions ? On 2/5/21, Ron <ronljohnsonjr@gmail.com> wrote: > 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@aol.com >> <mailto:rkrishna_pg@aol.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. >
В списке pgsql-general по дате отправления: