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 1uHtFW-00BpP8-L9 for pgsql-hackers@arkaria.postgresql.org; Wed, 21 May 2025 23:53:26 +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 1uHtFV-00CkM7-IX for pgsql-hackers@arkaria.postgresql.org; Wed, 21 May 2025 23:53:25 +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 1uHtFV-00CkLz-5e for pgsql-hackers@lists.postgresql.org; Wed, 21 May 2025 23:53:25 +0000 Received: from mail-pj1-x1031.google.com ([2607:f8b0:4864:20::1031]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uHtFS-000DaH-1C for pgsql-hackers@lists.postgresql.org; Wed, 21 May 2025 23:53:23 +0000 Received: by mail-pj1-x1031.google.com with SMTP id 98e67ed59e1d1-3081f72c271so6062856a91.0 for ; Wed, 21 May 2025 16:53:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1747871601; x=1748476401; 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=ydK9uqBfv+DTRQfQyhjExQHB7aEIqouU2Mv/HISCGmo=; b=f6z3qfzBk0rR8S2WkIQPQfvvQFXP5EymNSrJJMiyu5kiuKlvmTBUDKmPoO9okNqYJ2 LOboPQ0s0/+2eAfsaZJA0T0hEpu2943YpIEXyabZr1fuWkseUMGkAmYQIiFVZJdru5WA g7z+gHGJTsiRMjFQf47cjTXJI7RZO6TB+RV1V6KpBd8LMmF9iV6vVv1mrNmp1V7rXtHk 916P07dZXnXmgA1zWf9V12mRUfOAvI8oxa97tKG8Y6+hhHbkKrBf3b0xVNh5V+5erKeu g9tWlnslaDhhtHXZsntDFfFGMR1WI1e3t6+5rA/7t0WPoZL05eRMTTeSoz+LpO0qVx77 YSeg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1747871601; x=1748476401; 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=ydK9uqBfv+DTRQfQyhjExQHB7aEIqouU2Mv/HISCGmo=; b=qEMLShlH/bw0aBgnoU83kkmDCW5MotfY3T2/qX282EHEKufEgXqqKb5jmd68s8REOQ IHQ4Z2tranpLiSbC6mco9bUb5hX2rOCB7xBYAuKyKlqKEnIcrjtdNMUz9Wqx4/ns8cfS +3XdvUr3ZIaJUzqRi/+uQobP9BQg7J9a4oDPFsyIXvdFQRUNbHrydtMwuB30vzuWnVby oPIQVMXfiBJhzrbXQaN62+MdoAEo/W7MycjKeaZL1FejEhIHhyInH80y3jXuic0fuQQn Cef5aFf4kr4QrL/+2BYeP3y1NGgFskYcd/Kc/yV1ymW9aetMey7Ed45UPDIF93A4pJhQ u6tQ== X-Forwarded-Encrypted: i=1; AJvYcCWvZCEVVeAn0JXvVyRfXvTepPJGztGk78a2ujpuZMJ7EmNRrebBEvlwc7ycgfrRhcCBXpJMGT4VzPM4yJeA@lists.postgresql.org X-Gm-Message-State: AOJu0YxcyPPjSUDcpjAoRStht/PUWZal2Pfje5jrPid1A+nFMdJON57Z cJdJc1e0opJv+Ox3E15WsseyHhksB5hIggQi2ZKOClcSTxhv4klSlzzYpDXXOAr8FQ== X-Gm-Gg: ASbGncuFZo/YWwiCiRebXqctgNqzu7h3UnxjzgywGJDWGfSbeUNc+bMfljur1vQzJe1 kTpxgHGkTYqmGbgGI2U44nDL114qZvH2GjaHrkbzdzsLisMHdzNX/pH2j9W3nWT9BWVkuNVlyf+ Wx8v8ntOMdJLnWcrDSgZa/h67HB4MzrWDaAGSZvAr835nY72dYNShwArlUcdJLfsZu14B5ILYbS B5eLvPHFRSV9IUwfwYAEujJsus8pYh3PGUiS7RWrKWBYTjIbHr0ondcE8V+BJgcFVzsSpBbzjGB YJvtSkpi6huylMDIPScWEVyqcbxIDiscNkEpxPTzc+LtO47i9v+Mq7wSgtu0gAZZFxZzlCksZH9 yYnJbwcfYpLSalynMlsAasQ== X-Google-Smtp-Source: AGHT+IF131G3zGnWV34zj237f8X+/TUNkvf1w+N6hV4UeMPMcbyVmerLulxXTFNKyKn6WuVUIvA50g== X-Received: by 2002:a17:90b:4a8f:b0:310:8db0:16d3 with SMTP id 98e67ed59e1d1-3108db016d8mr7220711a91.17.1747871600889; Wed, 21 May 2025 16:53:20 -0700 (PDT) Received: from jeff-ws-bridge.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-30f3650003fsm4236733a91.30.2025.05.21.16.53.18 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 21 May 2025 16:53:20 -0700 (PDT) Message-ID: <7145b4b2bfa22b9ae7cb4c602defa050065a33cc.camel@j-davis.com> Subject: Re: Statistics Import and Export From: Jeff Davis To: Nathan Bossart 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 Date: Wed, 21 May 2025 16:53:17 -0700 In-Reply-To: References: <6886e8bffbccf14766ba66c08ca4bcc174c1c1d8.camel@j-davis.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.3-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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? Regards, Jeff Davis