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 1tK2Kr-006SfW-EP for pgsql-hackers@arkaria.postgresql.org; Sat, 07 Dec 2024 21:27:33 +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 1tK2Kn-00H3IB-Pu for pgsql-hackers@arkaria.postgresql.org; Sat, 07 Dec 2024 21:27:31 +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 1tK2Kn-00H3I3-B8 for pgsql-hackers@lists.postgresql.org; Sat, 07 Dec 2024 21:27:30 +0000 Received: from mail-pf1-x429.google.com ([2607:f8b0:4864:20::429]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tK2Kl-001YmO-Qc for pgsql-hackers@lists.postgresql.org; Sat, 07 Dec 2024 21:27:29 +0000 Received: by mail-pf1-x429.google.com with SMTP id d2e1a72fcca58-725d9f57d90so364381b3a.1 for ; Sat, 07 Dec 2024 13:27:27 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1733606846; x=1734211646; 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=tM4GVZsqJqzlSbWkQ45PmAhHUHnH13iXIQsR/76mQVM=; b=u0W+6ED0j+uBUYCYjmlm6lzXar7KdzlbZtyi9jXfRLh3CT1oRyBIUl+Vt1g1VmP7sq BwwjbOFZgXn9vX6XN3eISezQobAPAtue0Xq8f5tnOdwb+LIqwMZCRb0x2vFLQ+a5j+3+ p6vMo6D3qDgdCLY2FOg0MOjLX05FsKF3zqSEzMb4jOJexDOmYisKWeTEzd4lSJaxPxFD rZzoD+Z/0Wqj7YnyiCjyMmFNsUksvV6Qkvw0iHMcA3CWDXSgyGjthfLVsLR71okuNKfy eBwfe5xvvn0RUCFCDZa48TwGVIVcgbEngtrz3iObUn5P/gjD+h2IPv9tGAwOXcKn5us7 chAg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1733606846; x=1734211646; 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=tM4GVZsqJqzlSbWkQ45PmAhHUHnH13iXIQsR/76mQVM=; b=VmifKgZwHlkLvHDW9JGu6OMl+Z2kGa3fAHN8bjsVimQDWTI3lHJsFYp1ZugepUB7M9 b6afoBQNBDLfEr+6skoZ1KvQXXs6y6q8t7jimPsEdmwmffgQoji6VzTDCXVB4G34Oa3m /KReZduwbbkIuTb2hPY71Gc92h7bfDxdoJO701hWVzsoROCjJUkIEzePEXPQiakU54bg 1ZwzuV8eU3BwXCqhzPZizMxNf84O004S1wpB8yk5SLCiMRhEXQfYuwFpb8nbH3Kllrwt S9+a5COthti5+WhBiOJ16qCFpu5PzjuwCBXyqqiYAIPaEeag69Og3IBSXO5+yO2LYW9O d8Yw== X-Forwarded-Encrypted: i=1; AJvYcCVwZPFgosTgsEIu9fvkK/i+fhe1ytuJNUtWd9o5ccVgzmTUGopmdsZS5oIqlII8QNNg3mOT2zUvZOhLxHOV@lists.postgresql.org X-Gm-Message-State: AOJu0YxnjzPX3BfcChSXtx+7fVKVNwqVHpFpkMn+x+B5IZGOZ8MCjZ6d YbxZN621SSiRSElBczIUIisaA1QEBjtO8l7CpcRebrbhlzNCeIth4Dp5/TKxBw== X-Gm-Gg: ASbGncv3bAEWOY/mEw6fJB+2I+3h4ADs2rMZrMwSCZNeuPsPDX+3uW175iiig1Nr6iY W8NA/Q4pD+FKX8jWmeLe+Qc5RtDeadUqkUz/ccRDu/+VcRCNvi7iVi/gsXckGzOrJwHK87YQxdt LJeeKFlF8hsn4xkRkkiQicdQyFdkl6aePPZIpLlylxUx5IZOXKFWsfMqq/51F203NKkDLRnUvxk y+50pGyJLUIfHW0dQrQXgK92F2hwdz1ho7YZ5X7oxDkwIHtazjl9Cb0p1Sg0M6WCa4AFuiL/bJz FCbG5sAKAJ4P3m26czy8 X-Google-Smtp-Source: AGHT+IE7gt4OGqZrC9Swj083alY1nQn52/h+HYj+f6ycgu3Vuwh30bn62bPiW+QOeH2EM1PKrayeEw== X-Received: by 2002:a05:6a00:3e10:b0:725:996c:3a17 with SMTP id d2e1a72fcca58-725b80fdcc7mr12746481b3a.8.1733606846450; Sat, 07 Dec 2024 13:27:26 -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 d2e1a72fcca58-725a29e8e41sm4865945b3a.53.2024.12.07.13.27.25 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 07 Dec 2024 13:27:26 -0800 (PST) Message-ID: <3bd40d2c686608196b8e04c2aaac9c57c447aae6.camel@j-davis.com> Subject: Re: Statistics Import and Export From: Jeff Davis To: Corey Huinker Cc: Bruce Momjian , 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: Sat, 07 Dec 2024 13:27:23 -0800 In-Reply-To: References: <11bb2c7403d4a7421fe8b09df6737aa83976266e.camel@j-davis.com> <5d3a24216d15ce8a50d0fc085a13a410202014ca.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 Sat, 2024-12-07 at 14:56 -0500, Corey Huinker wrote: > This makes sense, though perhaps instead of --schema-only perhaps we > should pass both --no-statistics and --no-data. I don't envision a > fourth option to the new data/schema/stats triumvirate, but --no- > statistics shouldn't have a bearing on that future fourth option. +1, assuming such an option is wanted at all. I suppose it should be there for the unlikely (and hopefully impossible) case that statistics are causing a problem during upgrade. Regards, Jeff Davis=C2=A0