Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qxkMw-003BmJ-7e for pgsql-general@arkaria.postgresql.org; Tue, 31 Oct 2023 08:45:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qxkMu-001B7s-Hj for pgsql-general@arkaria.postgresql.org; Tue, 31 Oct 2023 08:45:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qxkMu-001B7j-22 for pgsql-general@lists.postgresql.org; Tue, 31 Oct 2023 08:45:00 +0000 Received: from mail-ed1-x531.google.com ([2a00:1450:4864:20::531]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qxkMr-003xiv-LQ for pgsql-general@lists.postgresql.org; Tue, 31 Oct 2023 08:44:59 +0000 Received: by mail-ed1-x531.google.com with SMTP id 4fb4d7f45d1cf-5437269a661so696902a12.0 for ; Tue, 31 Oct 2023 01:44:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1698741895; x=1699346695; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=m0FNTzPQBrVelVfQJ77aLnUFr/T2oKZU4wu6aR10r+4=; b=PMTwtjx0Ksy7+4ZPD4WCG0mFoA8MivySbFuYOgknSnKwgMIESQnoM3DHYgiORjUPRk xD82tXIabvq8FyPQsaE6+1c7gerd2uejwAqYVI2hKxG4CU1AT7U25kEuOrDg2YbwGxdQ h5SjrLFRO/LCvOkIAanpLHJ/12c3UhiIWOYEyeZfRV9DNE++Hzk61+83PBBFJI/XX6Q7 817C4HLn8KycHBQmtar0vserMN6gzlNySxi4VksnZ+1+oOuesm4NJSHeMLZsTOjnPV47 fPLy7t2skJkhzya0oditGfw25fiEvztYrYQoDYyAqhavbWA+lohrCYpsUCDIW2GDQzC1 +A8Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698741895; x=1699346695; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=m0FNTzPQBrVelVfQJ77aLnUFr/T2oKZU4wu6aR10r+4=; b=Y28ETdoCqTa5u08ggASWQIjm7fTtiPojVPFWlmEwa2D1yZZjRAs0z2HH70jl+0VwbG SdA9L3GRyIBVBQ9VlR4v2Fpiuozg7M6IkvkQw/4djnUHvg0rbT/hMc5xBRPnYUHINsby jiTOqXuDq2YTvykrqAg+yskNW0pPnjWW+v49AbeKUlw6S1ib2dLVg8ou8B3xbLMMLxX0 w2pikbcm+KgSti1WflpM9i1keHDoPw5k6mM+GkoHF54DWfXax9vqNM3T/YhENtXbGC77 OcEdJpaTHM1Y9cg2SFvcRyGxs6K/MKGJmR7xYD1Dfqct1bFzlsbkG1+Fd8gluadjr1xx rdHA== X-Gm-Message-State: AOJu0YyNdYkaZOCJlzvh7AKbGQdunK20DOHEDCUV5oiHJXac/jWCsr2C RKU4a50+Z8jIKLDxWJwKOScZYMSR5Aa+fZChCSBwuQ== X-Google-Smtp-Source: AGHT+IHWSPDccB0cYWI1oAW4Ng2G3CgTeU2Gx8X7yNsS/ZBViS0bKJFjJcYIdknx4ukJY1KrpjqEuQ== X-Received: by 2002:a50:d553:0:b0:542:fe59:2234 with SMTP id f19-20020a50d553000000b00542fe592234mr1827970edj.6.1698741895454; Tue, 31 Oct 2023 01:44:55 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:191:64d0:7629:41d2:568e]) by smtp.gmail.com with ESMTPSA id q19-20020a056402033300b0054354da96e5sm727565edw.55.2023.10.31.01.44.55 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 31 Oct 2023 01:44:55 -0700 (PDT) Message-ID: <5392fc2be0f09ca2cc063a6b25d0f9560d449808.camel@cybertec.at> Subject: Re: xmax not zero? From: Laurenz Albe To: Luca Ferrari , Guillaume Lelarge Cc: pgsql-general Date: Tue, 31 Oct 2023 09:44:54 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2023-10-31 at 08:23 +0100, Luca Ferrari wrote: > What puzzled me was that such xmax was non-zero for a > while (days). Inspecting pg_class.reloptions I found that accidentally > (?) disabled autovacuum on such table, my fault! > I should have checked pg_stat_user_tables at first! VACUUM won't modify "xmax", nor will it remove the row. Yours, Laurenz Albe