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.96) (envelope-from ) id 1wA7H6-0024pq-2n for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2026 14:19:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wA7H4-000XDy-11 for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2026 14:19:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wA7H3-000XDp-3C for pgsql-hackers@lists.postgresql.org; Tue, 07 Apr 2026 14:19:26 +0000 Received: from mail-wm1-x333.google.com ([2a00:1450:4864:20::333]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wA7H2-000000012to-1qSI for pgsql-hackers@lists.postgresql.org; Tue, 07 Apr 2026 14:19:25 +0000 Received: by mail-wm1-x333.google.com with SMTP id 5b1f17b1804b1-488af96f6b2so29694735e9.0 for ; Tue, 07 Apr 2026 07:19:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1775571561; x=1776176361; darn=lists.postgresql.org; h=message-id:date:content-transfer-encoding:content-id:mime-version :comments:references:in-reply-to:subject:cc:to:from:from:to:cc :subject:date:message-id:reply-to; bh=mjewPl0je34WP7fGhjLyna2ld4+ci25fZYj/iv2WDr4=; b=MAXRqaXjqP0GtbWo8Vyl7mxf/wf1fKjglbcrnv+ff071i7UGQAKgnADSXuRhQ8pCqQ 6IM28oPztaeXx+4c+bhyjssAb1fLp1mV1Dn2U2DQBIVpyffdkGlcCTygfRRF/5Jfs2BV o2yDCyy2GI6CUf07e/srTV3IOyeNVP/GQH98HSUqZU8L50QTCku67TfI8qKV5u9yv1jU oP+unp34jARVw3kKz5fVlSDf8ZQp4deqb5GtYpNuwY39g8U5Dp+yTMT5CU3BALlCFf9K vmrZj5yR1Ot4pfvvU/Et3RdKE/7RRU87l+qx5JtUCkajmOD750TcFDCRqKWIgD0sMF6H MUiQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775571561; x=1776176361; h=message-id:date:content-transfer-encoding:content-id:mime-version :comments:references:in-reply-to:subject:cc:to:from:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=mjewPl0je34WP7fGhjLyna2ld4+ci25fZYj/iv2WDr4=; b=qQvK/8Lnou7hTMcLgKoh2bspcWNQPcfChPH46h0slMiOJQPectUg8vvo3ZVTLCGpv6 NsTWONKxpTZuFqW4hOaVV69/yeRSFunU4/OC6CFErJ3gpoivg7Ov1ygGr7QN6Nv0S2oQ PlKMLmqsqrhV6FTzdbR/sv3mZIPUFYAfHtSs8XzRLgq4J5ZyKIHiuJFLAukQQIADwXwE WzvmKgJEoTBJU5kxP1jO+PA8xR/FGFZgZ3M1RVf/k/VA0WMlFy4oIekYBc31VMfELokw 3Yf+ASH5k8HLoHFOZ9pQoeMfogyIqpmHBqumeq+t9mfJTh9jL0YjkM2aw3pYSslxn/68 uuBg== X-Forwarded-Encrypted: i=1; AJvYcCWMJ7lexXcuX6WseSlrGv5xTdHa9auINFgHutRPV3pfQdWe2Ceoo/Sze0165Tcx+VzVNBSc7vIEHpZZs4DI@lists.postgresql.org X-Gm-Message-State: AOJu0YzCUUAE6az+2ECVbz2l/zI+NJN0MYy5Ctf2tOsmbSIDHWlhEzjK n4tUPK3uRMKS0/FDlOw1J4+FkzvZGObBLecGBMBDvojivHaXcq9KRcoRPMiIRGvSaBY= X-Gm-Gg: AeBDievLeS9wHlLN+2tU2KZvEcRW0qpIQU8xjYbmKPNCNjgyPzW1RwxsMxsKCAlwCRB y//uAkI73C4GBXafcEgkWV/uPdZJ6XkbrPgtQNUOH6amF9thnfjQsaYPoy0TinC/XsemhXp/dnl +7I5A3OqPtvLvZ+jgrNpvc7mrFn2zSOvQJqxyLzBr+MkKMixLvYVJ9RiWkDtHTlqsLtjuv8S8p+ gS4o6zyXAoqSneqChYZ+g8ThAWHKq1j6/e/MYpm0q5aZpogP1qLGSAIPiqVk4pxmR4CA/mnG7eo NOw218QbazfWJoZ3GDjyoz3jCyyxNn5Zicu6qxYDBH3MkgxBn4nlwDAeN76SnCxIkNjkXerMBfV KltlRf9rmMw5TVp7M98+ZnV9k9m+tVDjAPNXla4I1PjdW1DfLrvwzIT/r59Jbpy2fsWu7eAFVTa D3oVJNRSQQGwO0t06gUCpE/0Qtl+mxV3cswDc+ X-Received: by 2002:a05:600c:4ec7:b0:485:35a4:939f with SMTP id 5b1f17b1804b1-488997ebfbamr218470185e9.28.1775571561134; Tue, 07 Apr 2026 07:19:21 -0700 (PDT) Received: from localhost (109-81-168-142.rct.o2.cz. [109.81.168.142]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-4887e83682fsm583291545e9.7.2026.04.07.07.19.20 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 07 Apr 2026 07:19:20 -0700 (PDT) From: Antonin Houska To: "Hayato Kuroda (Fujitsu)" cc: 'Alvaro Herrera' , Mihail Nikalayeu , Srinath Reddy Sadipiralla , Amit Kapila , Matthias van de Meent , Pg Hackers , Robert Treat Subject: Re: Adding REPACK [concurrently] In-reply-to: References: <202604062213.cgo352cdsgsm@alvherre.pgsql> Comments: In-reply-to "Hayato Kuroda (Fujitsu)" message dated "Tue, 07 Apr 2026 12:32:32 -0000." X-Mailer: MH-E 8.6+git; nmh 1.8; GNU Emacs 28.3 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <225002.1775571560.1@localhost> Content-Transfer-Encoding: quoted-printable Date: Tue, 07 Apr 2026 16:19:20 +0200 Message-ID: <225003.1775571560@localhost> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hayato Kuroda (Fujitsu) wrote: > 02. SnapBuildProcessRunningXacts > = > Per my understanding, the db_specic snapshot can be also serialized. Is = it > possibility tha normal logical decoding system restores the snapshot and= obtain > the wrong result? I don't think that the database-specific xl_running_xacts WAL record affec= ts what SnapBuildSerialize() writes to disk: the contents of builder->committ= ed, etc. is updated by decoding COMMIT and ABORT records. On the other hand, with that kind of record, there's probably no reason to call SnapBuildSerialize(). Good catch, thanks. -- = Antonin Houska Web: https://www.cybertec-postgresql.com