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 1wHzfp-007glh-0A for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Apr 2026 07:49:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wHzfo-002Mk3-03 for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Apr 2026 07:49:32 +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 1wHzfn-002Mj5-1k for pgsql-hackers@lists.postgresql.org; Wed, 29 Apr 2026 07:49:31 +0000 Received: from mail-qt1-x841.google.com ([2607:f8b0:4864:20::841]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wHzfl-00000003JVX-1EIb for pgsql-hackers@lists.postgresql.org; Wed, 29 Apr 2026 07:49:30 +0000 Received: by mail-qt1-x841.google.com with SMTP id d75a77b69052e-506a6cf8242so87026571cf.1 for ; Wed, 29 Apr 2026 00:49:29 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1777448969; cv=none; d=google.com; s=arc-20240605; b=hu9Tt/MERm17Yf1ntch+7gRvmNv1R034wZugzvCs2nty0QP6VFhQL+GMRgM3jFo+Su iWNHyuANVpodP/41WvVzLbl1/tO6QWxehStw66Ni0FVZBY+6ZDymZV5d/+r5Rpqf4W2p 5dli1JhP2L0hboeIXB+oMr4rioVHIm2J5s9t/58ykY5+GkqnN0auMmC+kO+J57b01rcF gLUTpAWUooFwo23NZdyqIuuuWP7ATxNiHG41K8SgbPmeDCgTCqXnuyD9vqD+l5J5SYn7 jvWjbdOhsRRrkc/tyXoL2ybkF8G70Mhf74255geqsKm/T8CRQiVvRr/kBWyoPxtTP1Wh vwqw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=XDbJADYLkiHZSuJDhj5vV+apKCH6Dfcf7S9VlLsZ3g8=; fh=mAbQmAUni1C1QEG59er0deCCIPpWB1h/0GaFoMhFsTA=; b=T8jhm0uxwgo6lZSZXMFJEgWw5Gi3lKMMbiklhDd3srCK3VALQcc+04AIYEuIF4jsv/ xNwCDKwUJN/WN57LSn/Ig16sYJYrxx1BTbodOOs1phPlcEUgD8W8c6KpvcmdCpvOWxT8 ygsaNs9Ap4QzkGsFVpw+EWcSSKFVQ0ZqH9svOJxRTNE66aFgk5kvJyThQtlVp8W6tw5k 63IrN/xedCGoB8uxFgEJgc09QuR5qQeTHWLY87cC6Jsx9MUSuYTmAjWgkehKJr9agOIA Z5hY5mMtiUs6DkOBYogVN39Aeqe8kh8+FYbPFdgp6iESoLHqFK/MXED5OM8DMp1Q5FdQ CNPQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1777448969; x=1778053769; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=XDbJADYLkiHZSuJDhj5vV+apKCH6Dfcf7S9VlLsZ3g8=; b=G8ScZ7GXd+8J4/VOdEK9aMAVUPoNTSCz9U+LvCxT6cCiJeVuLmffBZIGWtYsJSRZkf 378B8SGhe9maU+Ota1oof3LbA+xe3sX/I0MCOTTiXIhiZhE/DWtW5Vmf/FnCCewwtPqH CmqOoJfHYEzKvWZR6BlZfCHNAimJuGQBa+KGu5zLium3tpJEMjtThXW6fX2j1SULsGN4 1WO8yktVtF8EyZ1//BFuCLyc6oElCi+FCuGuF6+6L6UH5sR2TPCur3CCBKShgaPWzv0f ZNqNYTqOGLM11+G9LutppW7p4NhhFCSMGAg7GDa3Iys601s4twnwMuA4OMSwBM4nz/66 B9ew== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1777448969; x=1778053769; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=XDbJADYLkiHZSuJDhj5vV+apKCH6Dfcf7S9VlLsZ3g8=; b=HZexplJa7RKPint1YOm0Ft+LNyJfZKTuD/J5R/VYyxmyFJyB0z2trUw86F617sYS5s +ttE2Yh+sPpzRBdEW+bAPe6ZttvpycfvSgNEAkk4HvGvaNCiH4bvSemKgeYWCpDiOykT 3fWMFef2Dy6YUiAwBq2Ip4hTA7z8/udj76zEPWevArR5cujIGCowqwuA4wTHCVhPB69R 7xhQXnfMDJKBH7YO9K+jcDFYBFItKbi7X4hiCJSrNQNi1wpLImYD3I7pUpwl+N/DGxcB ayC+J10iH1I0ucQfBf57Ql1Yxg5gOQSFLoKaSWjoB0jEBI8S56KeDD4YdS3f9ABa13Lj 4FiQ== X-Gm-Message-State: AOJu0YxqhAnkXPjzVtOqS3FDuQdXripV7musptoTGAeTmwTk0ctO/LLf 9nSmMCTq6UjuTzbRvSxu9djzl24+hlE3jJVdqg1GAMb0kqu/TTfTEfoqlSTXikJAyIpZuCVtjIw pCE+1FnjppxNt2uXGk1jaJNh/G0144Iw= X-Gm-Gg: AeBDietkpLJ5iOl6m4+98Mw+1nPpE4LPOUiqmPyKCLk7ZM8I7GtsCY7dhhJnwQNg0tj NdCla36HUvVMzWUJCnLnWDhh87mLAlWa1C2Lyc454gPK/nmAW/e1zyHMp6f59/98cH8qU/AtYGa g31tOOCkmUlKA7kX7ZGL8ETa7gZZ4IVxvMJvLhH+9MdR65O6J+sLcWMyHhptnjZ9FjUiiG2GwwM BcVMRh9QjLT8xNV+i8SQt/AtF0VsHoCA6AEo3PUsAZdzGdnaErsK297J6aLHL3PUgMHsRU64j/q 15c/dDAauk0kLRX/VewhkrcJZmL6EFdkCwZGY5vvOFDMeNk2RjqZTeSSf/HEB77Z2NbY9FPBw+f 8uFbH0rIM1c8VPMRrYaTAXgiHR0dTtuYeD+Qfgg== X-Received: by 2002:a05:622a:349:b0:50e:fcbc:6b6d with SMTP id d75a77b69052e-5100e12ef0cmr85238881cf.19.1777448967797; Wed, 29 Apr 2026 00:49:27 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: John Naylor Date: Wed, 29 Apr 2026 14:49:16 +0700 X-Gm-Features: AVHnY4K4R3WxsADNi-B2SRfw_0newH-7ni6lC7iC7UE6mOFTK8eUlFFx-QD9nhI Message-ID: Subject: Re: Inherit regression outputs rows in alternative ordering when run on other table AM than heap To: Pavel Borisov Cc: Postgres hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Mar 27, 2026 at 7:54=E2=80=AFPM Pavel Borisov wrote: > Existing inherit regression test results are tied to the particular > row order after UPDATE clause. The context is approximately the same > as in [1]. > > When run on different table AM it shows the following difference in outpu= t: I think it'd be beneficial to make regression tests more reproducible across different table AMs. It's worth asking how much the ongoing maintenance cost would be, since I imagine the one you're testing is not the only one that shows differences. --=20 John Naylor Amazon Web Services