Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1iejw2-0003rf-FQ
	for pgsql-hackers@arkaria.postgresql.org; Tue, 10 Dec 2019 18:08:34 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1iejw1-0004Te-88
	for pgsql-hackers@arkaria.postgresql.org; Tue, 10 Dec 2019 18:08:33 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1iejw0-0004TX-Uh
	for pgsql-hackers@lists.postgresql.org; Tue, 10 Dec 2019 18:08:32 +0000
Received: from mail-vs1-xe41.google.com ([2607:f8b0:4864:20::e41])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <alvherre@2ndquadrant.com>)
	id 1iejvt-0001AY-SP
	for pgsql-hackers@postgresql.org; Tue, 10 Dec 2019 18:08:32 +0000
Received: by mail-vs1-xe41.google.com with SMTP id g23so13751756vsr.7
        for <pgsql-hackers@postgresql.org>;
 Tue, 10 Dec 2019 10:08:25 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623;
        h=date:from:to:cc:subject:message-id:mime-version:content-disposition
         :content-transfer-encoding:in-reply-to:user-agent;
        bh=2ftEXvQem6r38AbeE12psy2Hk76WOa+SJYbRrVEpWMI=;
        b=aFGSFKdVbpW9LYgI5AAi7U+KOPTGyyN13cd7t6gr24wOfobVHQt6xakLWBG+IMioDZ
         z2fRmSqXlKXvABoSL2rWttKX+ovIeW+Xd+aUiIPD2OoyOBIqnaAwT/wOl85OY3B9OzVK
         61SnCGbtmGSLonQLrNUSTe9Ki8ZCbjnqRyQWNXOCaonrprGAB+5komtGoyr07KbUiWbi
         dxkEMTlsIVrSf2K3XKOU7YSJ1puH5eetq95mL0x9B2RpySQoVG8dS3TSV/LD/ZFD8yzm
         XzwMckVd0JX1YBHP9Qelv2yYgmQw5vVhtr1Ok8a7RVb1IsKkt0rXJxaaYg3XRfhYOA53
         q/1g==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version
         :content-disposition:content-transfer-encoding:in-reply-to
         :user-agent;
        bh=2ftEXvQem6r38AbeE12psy2Hk76WOa+SJYbRrVEpWMI=;
        b=RGItdk+9B9B2dMsyiad9MzOMakIbW/PODPcW52yGgEQSquKs11/ew1mEX2vkOU1ybI
         X0REfNaXjtpLMlhVLvttqPxt9WcKtaNOP6dtQ0knb5Sjbf8Y5ZzX20H+1JNufcTuyQnz
         iM19wNW4n1S+TmQPcuaowVHKo3/lKTWfsgnb1zfYvqMxwzZ+Tj3kZQe00UqK8Y/S1aO5
         Q1i2XYhpWPxDBsGqajrZTIZH8nOQz8XD4nAUTTAFrtr6fbWcbRLSp7jUCm4ADIamMCx3
         TQULuOeysOPS+OUrRBMI0XAYKfioSKurkNINKteuAsa8+PlbdRgMcJIIXD7HOi4jb0++
         UphQ==
X-Gm-Message-State: APjAAAV+XuZo5AcLk1pJ9IztDaLqGeKnFU9ASSDJwbzzmCBMkC0S2pPx
	c7pIQ0A3hwdQUDu4h4d51qXX8A==
X-Google-Smtp-Source: 
 APXvYqy9nHhGTZH+qC8v/MlZ53QCAXVlZbgS2W72qZiFQ+oxphwzuTOqxmS6I8tOYGDYiArl0jxybw==
X-Received: by 2002:a67:ad0c:: with SMTP id
 t12mr25941293vsl.232.1576001304379;
        Tue, 10 Dec 2019 10:08:24 -0800 (PST)
Received: from nimloth.alvh.no-ip.org ([200.73.2.58])
        by smtp.gmail.com with ESMTPSA id a6sm2411989vsr.9.2019.12.10.10.08.23
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Tue, 10 Dec 2019 10:08:24 -0800 (PST)
Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000)
	id 0BBC03009FF; Tue, 10 Dec 2019 15:08:21 -0300 (-03)
Date: Tue, 10 Dec 2019 15:08:21 -0300
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>,
	pgsql-hackers@postgresql.org
Subject: Re: xact_start for walsender & logical decoding not updated
Message-ID: <20191210180821.GA12847@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <20191210115903.x5j3rfxtr3notsut@development>
User-Agent: Mutt/1.10.1 (2018-07-13)
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk

On 2019-Dec-10, Tomas Vondra wrote:

> On Tue, Dec 10, 2019 at 09:42:17AM +0900, Kyotaro Horiguchi wrote:
> > At Tue, 10 Dec 2019 00:44:09 +0100, Tomas Vondra <tomas.vondra@2ndquadrant.com> wrote in

> > I'm not sure how much xact_start for walsender is useful and we really
> > is not running a statement there.  Also autovac launcher starts
> > transaction without a valid statement timestamp perhaps for the same
> > reason.
> 
> Maybe, but then maybe we should change it so that we don't report any
> timestamps for such processes.

Yeah, I think we should to that.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services