Re: Max connections reached without max connections reached

Поиск
Список
Период
Сортировка
От Dilip Kumar
Тема Re: Max connections reached without max connections reached
Дата
Msg-id CAFiTN-sRe7gDkR1tzE4r-PSft0JKj5yirv2k0+sgggk7Q5EePg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Max connections reached without max connections reached  (Dilip Kumar <dilipbalaut@gmail.com>)
Список pgsql-general
On Thu, Nov 25, 2021 at 9:50 AM Dilip Kumar <dilipbalaut@gmail.com> wrote:

> > Does that shed any light?
>
> Seems like some of the processes are taking a long time or stuck while
> reading/writing SLRU pages, and due to that while creating a new
> connection the backend process is not able to check the transaction
> status (from pg_xlog) of the pg_class tuple and gets stuck/taking a
> long time in a startup.

Correction, I mean pg_xact (pg_clog in older version) not pg_xlog :)

-- 
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com



В списке pgsql-general по дате отправления:

Предыдущее
От: Dilip Kumar
Дата:
Сообщение: Re: Max connections reached without max connections reached
Следующее
От: Ron
Дата:
Сообщение: Re: Inserts and bad performance