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  (Ron <ronljohnsonjr@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ltree and PHP
Следующее
От: "Jain, Ankit"
Дата:
Сообщение: RE: cant connect to localhost:5432 (but unix socket ok)