Re: Autovacuum and idle_session_timeout

2021-12-30 Thread Japin Li
On Fri, 31 Dec 2021 at 00:24, Tom Lane wrote: > Japin Li writes: >> On Thu, 30 Dec 2021 at 18:53, Guillaume Lelarge >> wrote: >>> pg_dump works in a single transaction, so it's already dealt with >>> idle_in_transaction_timeout. Though I guess setting both would work too. > >> Attached fix th

Re: Autovacuum and idle_session_timeout

2021-12-30 Thread Guillaume Lelarge
Le jeu. 30 déc. 2021 à 17:25, Tom Lane a écrit : > Japin Li writes: > > On Thu, 30 Dec 2021 at 18:53, Guillaume Lelarge > wrote: > >> pg_dump works in a single transaction, so it's already dealt with > >> idle_in_transaction_timeout. Though I guess setting both would work too. > > > Attached fi

Re: Autovacuum and idle_session_timeout

2021-12-30 Thread Tom Lane
Japin Li writes: > On Thu, 30 Dec 2021 at 18:53, Guillaume Lelarge > wrote: >> pg_dump works in a single transaction, so it's already dealt with >> idle_in_transaction_timeout. Though I guess setting both would work too. > Attached fix this, please consider reveiew it. Thanks. This seems rath

Re: Autovacuum and idle_session_timeout

2021-12-30 Thread Guillaume Lelarge
Le jeu. 30 déc. 2021 à 12:01, Japin Li a écrit : > > On Thu, 30 Dec 2021 at 18:53, Guillaume Lelarge > wrote: > > Le jeu. 30 déc. 2021 à 11:44, Japin Li a écrit : > > > >> > > pg_dump works in a single transaction, so it's already dealt with > > idle_in_transaction_timeout. Though I guess setti

Re: Autovacuum and idle_session_timeout

2021-12-30 Thread Japin Li
On Thu, 30 Dec 2021 at 18:53, Guillaume Lelarge wrote: > Le jeu. 30 déc. 2021 à 11:44, Japin Li a écrit : > >> > pg_dump works in a single transaction, so it's already dealt with > idle_in_transaction_timeout. Though I guess setting both would work too. Attached fix this, please consider reveie

Re: Autovacuum and idle_session_timeout

2021-12-30 Thread Guillaume Lelarge
Le jeu. 30 déc. 2021 à 11:44, Japin Li a écrit : > > On Thu, 30 Dec 2021 at 17:18, Guillaume Lelarge > wrote: > > Hello, > > > > I've been reading the autovacuum code (the launcher and the worker) on > the > > 14 branch. As previously, I've seen some configuration at the beginning, > > especiall

Re: Autovacuum and idle_session_timeout

2021-12-30 Thread Japin Li
On Thu, 30 Dec 2021 at 17:18, Guillaume Lelarge wrote: > Hello, > > I've been reading the autovacuum code (the launcher and the worker) on the > 14 branch. As previously, I've seen some configuration at the beginning, > especially for statement_timeout, lock_timeout and > idle_in_transaction_ses