| From: | Atul Kumar <akumar14871(at)gmail(dot)com> |
|---|---|
| To: | Ron <ronljohnsonjr(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: vacuumdb not letting me connect to db |
| Date: | 2021-02-05 08:15:39 |
| Message-ID: | CA+ONtZ5VcPA1s5fuHb6+x4W_Nv9SrFdtDG+H3OKAiSLHgn-7Yw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
ok, How do I resolve it ?
Any suggestions ?
On 2/5/21, Ron <ronljohnsonjr(at)gmail(dot)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(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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jain, Ankit | 2021-02-05 13:16:26 | RE: cant connect to localhost:5432 (but unix socket ok) |
| Previous Message | Tom Lane | 2021-02-05 05:33:03 | Re: ltree and PHP |