Re: Database connection pool expiration
| От | Calvin Kim |
|---|---|
| Тема | Re: Database connection pool expiration |
| Дата | |
| Msg-id | 80E28CE6-DCE0-4E66-8B50-EFF65923E7DD@gmail.com обсуждение исходный текст |
| Ответ на | Re: Database connection pool expiration (Shreeyansh Dba <shreeyansh2014@gmail.com>) |
| Ответы |
Re: Database connection pool expiration
|
| Список | pgsql-admin |
Hi,
I have checked both and they were all commented out, so they were disabled.
Could there be some other db config to check for?
Thanks.
Calvin
Sent from my iPhone
There may be several performance factors which might be causing the DB connection expired before completing long running transactions. However, you can consider tweaking statement_timeout and idle_in_transaction_session_timeout parameter.On Mon, Jan 7, 2019 at 9:32 AM Kuk Hyun Kim <khk800123@gmail.com> wrote:Hi,
Recently, developers are saying that the DB connection is getting
expired causing issue while running long transactions.
Is there a such configuration setting in Postgres and what would be
the default and recommended value for this?
Regards,
Calvin
В списке pgsql-admin по дате отправления: