Re: Autovacuum and idle_session_timeout

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Japin Li <japinli(at)hotmail(dot)com>
Cc: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Autovacuum and idle_session_timeout
Date: 2021-12-30 13:18:42
Message-ID: CAECtzeU_TdPMNCSBGof49cLBsGa=Ap=c8MzS=-8hLQ+2QPkTCQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Le jeu. 30 déc. 2021 à 12:01, Japin Li <japinli(at)hotmail(dot)com> a écrit :

>
> On Thu, 30 Dec 2021 at 18:53, Guillaume Lelarge <guillaume(at)lelarge(dot)info>
> wrote:
> > Le jeu. 30 déc. 2021 à 11:44, Japin Li <japinli(at)hotmail(dot)com> 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 reveiew it. Thanks.
>
>
I've read it and it really looks like what I would have done. Sounds good
to me.

--
Guillaume.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message houzj.fnst@fujitsu.com 2021-12-30 13:39:37 RE: row filtering for logical replication
Previous Message Dilip Kumar 2021-12-30 12:29:51 Re: Fix BUG #17335: Duplicate result rows in Gather node