Re: vacuumdb not letting me connect to db

Поиск
Список
Период
Сортировка
От Ron
Тема Re: vacuumdb not letting me connect to db
Дата
Msg-id 9645df52-2cdc-9e9e-b43c-d388c1aa7951@gmail.com
обсуждение исходный текст
Ответ на Re: vacuumdb not letting me connect to db  (Atul Kumar <akumar14871@gmail.com>)
Ответы Re: vacuumdb not letting me connect to db  (Atul Kumar <akumar14871@gmail.com>)
Список pgsql-general
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> 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 по дате отправления:

Предыдущее
От: Atul Kumar
Дата:
Сообщение: Re: vacuumdb not letting me connect to db
Следующее
От: Pavan Pusuluri
Дата:
Сообщение: Unable To Drop Tablespace