Obviously... don't use 300 threads.
On 2/5/21 2:15 AM, Atul Kumar wrote:
ok, How do I resolve it ?
Any suggestions ?
On 2/5/21, Ron <ronljohnsonjr@xxxxxxxxx> 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@xxxxxxx
<mailto:rkrishna_pg@xxxxxxx>> 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.
--
Angular momentum makes the world go 'round.
