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 1uI7nC-00GBai-Av for pgsql-hackers@arkaria.postgresql.org; Thu, 22 May 2025 15:25:10 +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 1uI7nB-00454O-3o for pgsql-hackers@arkaria.postgresql.org; Thu, 22 May 2025 15:25:08 +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 1uI7nA-0044wK-Q7 for pgsql-hackers@lists.postgresql.org; Thu, 22 May 2025 15:25:08 +0000 Received: from mail-il1-x136.google.com ([2607:f8b0: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 1uI7n8-000KQw-1G for pgsql-hackers@lists.postgresql.org; Thu, 22 May 2025 15:25:07 +0000 Received: by mail-il1-x136.google.com with SMTP id e9e14a558f8ab-3dc6f6530c5so33275095ab.3 for ; Thu, 22 May 2025 08:25:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1747927506; x=1748532306; darn=lists.postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=E7x4BCiWJzOpEt+N/A/IdYuxhVlOYLu1hx/TDGJIPXE=; b=i/5AwU+GeCe1t7RljB5p1hcJqvhODL/tfKR7Is4liE3Cr966hccGGieHxKAiXRAF1U vkcB6O7n31NrZkFeTxJmqIKt3tdR6IxYMtVVwhbQQtKy2M/RPNtKCwKVm6bmoPjFlJPi 5XuujpCy1fjONLa+cSE4pzAX4JHooGIhoWzRqJL4apI43inUk+QrwMFdmjc0a3r3v8Dh VJMQ2ki9QrqB5iQemTc0h1I/1hYmhT89YRlBzgFPGIifpwrOqMYTAJravT5JmaxH/o3q IGUmhs+qYzUVoj4X+J72HQq1fvC9NjbMqP5fakhamuRw1Rf/6D7htLpqsqSIzUk/XyI+ OJQQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1747927506; x=1748532306; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=E7x4BCiWJzOpEt+N/A/IdYuxhVlOYLu1hx/TDGJIPXE=; b=g/It3JY01zU/AwY3F0uIpgJTw9PJ/6Yi/r1YhadtxV9mSR4Zg7qZ+dnmvTAKrTK9SG v33Si2o76Ufv44W4yhEPj8XX2Ty8B4hO99awlwu5PT3PI9XivgR+FEmIgl8RkjfEOv1s UgL21G1frrJxNnrPUmQTV0k23tI/LH9CEL5Ofj30bWJ6xx53iOlXGuhSiJVAoNdJg0qB +cHFaofbgODHTp2w//WRv2NPNNuupMpyu2rbw8twbhzCYaJtxCZXRwYRZwJuVdFnuUV+ JfwE5dBHr8sQnCYRPf5VL0DEWpNFkQ2cMQpMYxPrhcObA0yDBv+zzlP12c0221xlzhGd dZ3w== X-Forwarded-Encrypted: i=1; AJvYcCX4EtEgTwSxjuqrg6Zbn5OC0pWmla8u9kzSIwKf3mnBwcO5Ef1gs8SbdOuq9wy0KB8hOeAYkR/d6TaBPp5f@lists.postgresql.org X-Gm-Message-State: AOJu0YzAXarWiSiZBVyfcON0E0ENzLum28/yM48rsOU0UC2jitMGMf0u trpOIA+OXaZnxD/Lf445WeK+xhWQuotdE9m9DRA789fJX7Wnmml3lgff X-Gm-Gg: ASbGncvsSDMFVNiZ6TIrpqllbm9kWBe20VTPuEx2WAkmldCpqlwQWVv33oGAes30PYI QDJ8oCDyLZW1TW8VNf3CU/NGXTbmmTZ98RadNRwRhbIetoDvsAiUc0YBviDesSxdk1HdIogsb1P tqg7gXw9m4NU9eMZ+UrAimDM9BkM8Pcpv1bjQA5g+L6jfQUbLDpV6ER4A5DuSwL2mX1J/bSPbcQ YUt/qdoB3UerI4YrW2Y7vdaNWbD1oDdsYtccr3Q0JwDsPqGx8JKGikWUkd9LpvwIVYd1LHtF6kW F83jE9LvkxXkNebUtSnLxpOx9u0RmiW9GIeFr5VA0ZtyXDpTK96OrnreSiKojg44wSUq85ZGU0D CqQU1HbC1Ly6jPNitUuqR8hzacGMVbdpYW1aAMTcD9A== X-Google-Smtp-Source: AGHT+IEZufhRaZFaLYKU7zVhL5wTzxpCHCB7wazy2jaqDXaIwMsmtR0VRal3pInbSj+YSquuoggGGA== X-Received: by 2002:a05:6e02:180e:b0:3dc:8b57:b760 with SMTP id e9e14a558f8ab-3dc8b57b836mr42651045ab.16.1747927505878; Thu, 22 May 2025 08:25:05 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-4fbcc4af638sm3072273173.105.2025.05.22.08.25.04 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 22 May 2025 08:25:05 -0700 (PDT) Date: Thu, 22 May 2025 10:25:03 -0500 From: Nathan Bossart To: Jeff Davis Cc: Hari Krishna Sunder , 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 Subject: Re: Statistics Import and Export Message-ID: References: <6886e8bffbccf14766ba66c08ca4bcc174c1c1d8.camel@j-davis.com> <7145b4b2bfa22b9ae7cb4c602defa050065a33cc.camel@j-davis.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <7145b4b2bfa22b9ae7cb4c602defa050065a33cc.camel@j-davis.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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