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 1tFmuG-00Fxys-8B for pgsql-hackers@arkaria.postgresql.org; Tue, 26 Nov 2024 04:10:32 +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 1tFmuE-003WGO-UP for pgsql-hackers@arkaria.postgresql.org; Tue, 26 Nov 2024 04:10:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tFmuE-003WGG-Ea for pgsql-hackers@lists.postgresql.org; Tue, 26 Nov 2024 04:10:30 +0000 Received: from mail-pj1-x1030.google.com ([2607:f8b0:4864:20::1030]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tFmuC-003skh-5i for pgsql-hackers@lists.postgresql.org; Tue, 26 Nov 2024 04:10:29 +0000 Received: by mail-pj1-x1030.google.com with SMTP id 98e67ed59e1d1-2e3686088c3so4161885a91.0 for ; Mon, 25 Nov 2024 20:10:27 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1732594226; x=1733199026; 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=8lqGbKjwF4Ym87yYfx8kqz0W6dwAwchvgaeFuI7OBzQ=; b=1sfLE89I3bePVhf5FXA2WdnOL4/5R2DfNCTsHEw9BrLYmEQxvpd+IHirRoyzj/Clai CsBqnR/9mjODQl14JrCtJz2Z2dSWlVEsn4jLkc39UwETfPIhmVR0xBzthVmhb7C/ZUjW 1A0GGmnwUfGgrUKkdn6mk9s95H8arqPD4IJ7HxXo8/qunbYa2JP6j8M/0PtTl8D0W1E1 1yq+Bq58syEu54Cs6wxfd044v96HlFAfcHzBmjAwvRw/KwoRxAYjlUPaLE2sH9ENz28C 3S8kEvrIrjZ6wWGGwk6VXFQdmR5h1T1X0dPRx1xJK9khhFmWUHUhKj6ipS+KTzrF73K1 ZJzg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732594226; x=1733199026; 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=8lqGbKjwF4Ym87yYfx8kqz0W6dwAwchvgaeFuI7OBzQ=; b=hiwnjVcUmsqn9ZciiwltdV/6rjpSbLu9nWUr8Ae78V64KLAURNCkV9CWrs8t0nAR7U rMh+i/+ykr2paY5R7A1F41zXkWGOgXW+7sn9GRLxVePkV6rlurAOcQPfBhj//ZoGWSzP a5U5AuVF+9oGbSndYD1TWPl1oCIQBBHvcBgmqft91wlQnvto1myHLRPFiqTYEAz5+nA2 GgArS3bxBH5wvC0FOfaKggKqJM87w7xpp2wXK2TxyN6mMUga+Xp0zBWZpupRGBho9NKP +hpZ76GA3ypLUPtKChsyRIE9PJd6JazUfjCDy83m0m+/haO3XigEe6GI6G4o43Q5c/IG MJOA== X-Forwarded-Encrypted: i=1; AJvYcCXOwB42CpBojsEHPPRece71LpRsKP7jCikX0Fvv6RVNU3YYAg/Apcy4hc0lUH6X+aw/gHrCsfsf0xQ/7WA0@lists.postgresql.org X-Gm-Message-State: AOJu0YwsdA/ydx/5SJROXFAfZz/5a4ySza/NGtK4FxJ0DpZ8mHQjvUy5 3kjEyp17uRUIlfNh8UBk4Rnq23nJ3IWCsqKdL6SCl2QFmdgIvTGSwXZ09ASkXA== X-Gm-Gg: ASbGncv2qmMlKtHF3NbDENOIUhm2wtz/DpOwSh1vtCBSOI5P1o4BxwffjE+pZWaSazO oft7GjDfUKrOyTVVThNwDe+sA8V80Zwz4awzvDIim5CDtuN8JguGLOqaMy2xsF9/i0Gd/KqGorZ nYRWSzUYJMUfxCOgiSDMXIOQe7jgmyDpgn+87fmDP+lvtW2hFSIPtylsZfCxq23nF0WCU+aSHXj gMS6IGfSlRLBSTfVwyKl5m6T/J4seaBvCeKuUpH0urFtK3QrjzqBAU8qftnf5oTc7sVRAs7Pwd+ KD89ydA/FdUZRTiI X-Google-Smtp-Source: AGHT+IF7k5hVZK2OJcQnwIXBGp6tapa6uqpoJQ4Z7/I0QvlXTlgxNE//L7ix0QTCs3I+s04M406kTQ== X-Received: by 2002:a17:90b:3908:b0:2ea:7179:5c2b with SMTP id 98e67ed59e1d1-2eb0e88140dmr19077294a91.35.1732594225917; Mon, 25 Nov 2024 20:10:25 -0800 (PST) Received: from jeff-laptop.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-2ead033503csm11208274a91.28.2024.11.25.20.10.23 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 25 Nov 2024 20:10:24 -0800 (PST) Message-ID: <5d3a24216d15ce8a50d0fc085a13a410202014ca.camel@j-davis.com> Subject: Re: Statistics Import and Export From: Jeff Davis To: Corey Huinker , Bruce Momjian Cc: jian he , Matthias van de Meent , Tom Lane , Nathan Bossart , Magnus Hagander , Stephen Frost , Ashutosh Bapat , Peter Smith , PostgreSQL Hackers , alvherre@alvh.no-ip.org Date: Mon, 25 Nov 2024 20:10:22 -0800 In-Reply-To: References: <11bb2c7403d4a7421fe8b09df6737aa83976266e.camel@j-davis.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu2 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2024-11-18 at 20:29 -0500, Corey Huinker wrote: > Attached is a re-basing of the existing patchset, plus 3 more > additions: Comments on 0003: * If we commit 0003, is it a useful feature by itself or does it require that we commit some or all of 0004-0014? Which of these need to be in v18? * Why does binary upgrade cause statistics to be dumped? Can you just make pg_upgrade specify the appropriate set of flags? * It looks like appendNamedArgument() is never called with positional=3Dtrue? * It's pretty awkward to use an array of arrays of strings when an array of structs might make more sense. Regards, Jeff Davis