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 1uIBY3-00HLIq-8C for pgsql-hackers@arkaria.postgresql.org; Thu, 22 May 2025 19:25:47 +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 1uIBY2-007KCK-2m for pgsql-hackers@arkaria.postgresql.org; Thu, 22 May 2025 19:25:45 +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.94.2) (envelope-from ) id 1uIBY1-007KCC-Pq for pgsql-hackers@lists.postgresql.org; Thu, 22 May 2025 19:25:45 +0000 Received: from mail-lf1-x136.google.com ([2a00:1450:4864:20::136]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uIBXz-000MLU-20 for pgsql-hackers@lists.postgresql.org; Thu, 22 May 2025 19:25:44 +0000 Received: by mail-lf1-x136.google.com with SMTP id 2adb3069b0e04-550eb498fbbso7870301e87.2 for ; Thu, 22 May 2025 12:25:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1747941942; x=1748546742; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=QasK2o8aMX38UYlj1fn7oUeZXLtBIG1/rRgdlBOIkOs=; b=OYEpZfhH0niQTjeGDcxL3azNxjgzzyFTqTLyLlPBCKCo0hTMiOF0//yQcpn85fAXIG el3GOdALe/lwJY3qNeJ/b5zFEkxjmVLHww6JyfXymb3ApZEdhJ5lcNLz40USHlWSofWj 90T63vJgtTzGSZiCWjAlTme43XiaKGm8F1mkFSJ1gLrF7xK3leB3yTRRbRv4W6S3Fyo2 VtwwX5YVHJCRAq2h7fkAnVGutg6DBzek9lDvtdbsZoNAp45CJPcPbYld9iNLyMs+fN8c 7JcDcaHkq+awMqGL8Wc+GmLvbQOC8x3VJcrrOwNs6VeWQ3Oi1qCOEozu/4ZENHJG9Cju gjjw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1747941942; x=1748546742; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=QasK2o8aMX38UYlj1fn7oUeZXLtBIG1/rRgdlBOIkOs=; b=iNqf/AQLbEEGn3RLkb9L3GWWHgJc/Zi+nHHvRFmyHtJphiQOOeEE+8mXxw7i2yATFL Fc3ylJnQv6QZLboUpt6B0YNX2Fgd6IRMwVz7gRsQwA+78Z58LwAP1PVkVBNP81O2Rgy/ 1f3RvYGLthnZRoQ0LmDeMBVtMBSxPeyXw6PvqM3oA8Ggdfn3JZ8DMG/qmglvp4TFaYop xpCc0MGhQsaNrVHE63seI+k7BWhM/er+bF4tyqORleh9OiIOszg08n0v0BmOsP1G6Riu xVFMlN5mFW7XgFBgF1WslizFgvwra+47tILrYdfJMXP/RjDAMte6ZUSIjjJscEe2V+2h IeXA== X-Forwarded-Encrypted: i=1; AJvYcCW9vdaLF6DatVo9cksDwvw2l4bZGINX4gYF055j5ZSNLVI75/sOcBiflVMZwzjFK0iXK1acZr5+B1CeiYQ+@lists.postgresql.org X-Gm-Message-State: AOJu0YyM2EhqRozkkhZGhcjNLvmlOv3tF2Tb7rCuF3//gnk4R8vqoz21 wR2QLKohWx+vIeP/Yv1bzyecnk8uHtYTAYsQOheC8X3tKC9kE0kWeg0ftxpsA6GsEn781I2+Xvh icfcMvGCn+6dgEQ+YdZYdK1QZ/jHq5rU= X-Gm-Gg: ASbGncs5tqCp29sxGTWW3Iw8SfixdvZgWsEKnqFcb8HuakjYLlaGkXUmF41se5cpk+x EaYWRE4TTiHJZELa1bnDFhWzAUeb7HoYBX0florAv4FlbKUs3hyp2U39vMred/n+eWgZmfu2P5p R0BxZ4Tre6tuZMHahQ7awW07bSMK2g3j9HQY5kFfjDSHI= X-Google-Smtp-Source: AGHT+IFdluaYIPgvM7JZGwpMcmoHamsCOyBVokgREZQNEnpAfGFTBjfZCD1L2tcdujQg5fEjgHhQ4bKpNdZqpapX4+4= X-Received: by 2002:a05:6512:630e:b0:54f:c1ae:f1b6 with SMTP id 2adb3069b0e04-550e99648bemr7080501e87.56.1747941942056; Thu, 22 May 2025 12:25:42 -0700 (PDT) MIME-Version: 1.0 References: <6886e8bffbccf14766ba66c08ca4bcc174c1c1d8.camel@j-davis.com> <7145b4b2bfa22b9ae7cb4c602defa050065a33cc.camel@j-davis.com> In-Reply-To: From: Hari Krishna Sunder Date: Thu, 22 May 2025 12:25:29 -0700 X-Gm-Features: AX0GCFsL_Z48CKZ0F9F1ribyRTS4ZZAS-U8qi3ox9VGAVbM49ia--dMoWne3WYo Message-ID: Subject: Re: Statistics Import and Export To: Nathan Bossart Cc: Jeff Davis , Corey Huinker , Robert Treat , Robert Haas , Andres Freund , Tom Lane , Michael Paquier , jian he , Bruce Momjian , Matthias van de Meent , Magnus Hagander , Stephen Frost , Ashutosh Bapat , Peter Smith , PostgreSQL Hackers , alvherre@alvh.no-ip.org Content-Type: multipart/alternative; boundary="0000000000008b5d940635be7259" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008b5d940635be7259 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thanks for the help. This has unblocked us! On Thu, May 22, 2025 at 8:25=E2=80=AFAM Nathan Bossart wrote: > On Wed, May 21, 2025 at 04:53:17PM -0700, Jeff Davis wrote: > > On Wed, 2025-05-21 at 16:29 -0500, Nathan Bossart wrote: > >> I don't know precisely where that line might be, but in this case, > >> the > >> dumped stats have no hope of restoring into anything older than > >> v18... But I see no particular benefit from moving the complexity > >> to the > >> import side here. > > > > That's fine with me. Perhaps we should just say that pre-18 behavior > > differences can be fixed up during export, and post-18 behavior > > differences are fixed up during import? > > WFM. I've committed the patch. > > -- > nathan > --0000000000008b5d940635be7259 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks for the help. This has unblocked us!

On Thu, May 22, 2025 at 8:25=E2=80=AFAM Nathan Bossart <nathandbossart@gmail.com> wrote= :
On Wed, May 21= , 2025 at 04:53:17PM -0700, Jeff Davis wrote:
> On Wed, 2025-05-21 at 16:29 -0500, Nathan Bossart wrote:
>> I don't know precisely where that line might be, but in this c= ase,
>> the
>> dumped stats have no hope of restoring into anything older than >> v18... But I see no particular benefit from moving the complexity<= br> >> to the
>> import side here.
>
> That's fine with me. Perhaps we should just say that pre-18 behavi= or
> differences can be fixed up during export, and post-18 behavior
> differences are fixed up during import?

WFM.=C2=A0 I've committed the patch.

--
nathan
--0000000000008b5d940635be7259--