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 1tzNKg-001Ez9-6d for pgsql-hackers@arkaria.postgresql.org; Mon, 31 Mar 2025 22:10:14 +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 1tzNEt-00D9oP-0N for pgsql-hackers@arkaria.postgresql.org; Mon, 31 Mar 2025 22:04:15 +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 1tzNEs-00D9n7-Hl for pgsql-hackers@lists.postgresql.org; Mon, 31 Mar 2025 22:04:14 +0000 Received: from mail-pl1-x632.google.com ([2607:f8b0:4864:20::632]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tzNEq-002MGG-19 for pgsql-hackers@lists.postgresql.org; Mon, 31 Mar 2025 22:04:14 +0000 Received: by mail-pl1-x632.google.com with SMTP id d9443c01a7336-225df540edcso109315615ad.0 for ; Mon, 31 Mar 2025 15:04:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1743458649; x=1744063449; 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=q8FNXZbFjAbELISbB4g1RdZyYPcKn6FCVA9dYpxQAC4=; b=f9v0DyMlaGuKruKkWiXho7CpA0QKlvmJzAKJkIMmRh5UwaNlCUvKYCtCcIJxvhTuPZ K15GcfNreuMauzJTWqCUL3D9QpZJCR8H3UGqk9+6uk7CfCmQtHcGzokX+C+dSJeX2W2M yklh9GQYklH0YR8K3cl8IPQBsmSszaRYhHX1sU41OTjaX2SI+EHkaOVAPn9uRF+14Kcm yvIBxjK018BTsf27ot3pp68K5htOJGyltp7wpXPXL8cXvNeFaK2ovFSNj6kFBaGCEH03 MsSrKlWLT6tCmvNG1O85qq1gEdh/P+eNWIAGcnh8bEQ1S8/CZ/1Wa3aQETMNfi7Falk1 lY7Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1743458649; x=1744063449; 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=q8FNXZbFjAbELISbB4g1RdZyYPcKn6FCVA9dYpxQAC4=; b=DonVSIeQAS8Q5bd/6Q/JhsJMZy4q4wsDuYg5JOXQhQlLaOb8XaFFfCOJjKXpTLdTUv cckmkL3SNJwDmHFyMuSOfeaV82lxql6hR3Mn9352iXkpJdCzsS1o8N1Us/pz1O1SImol 7M6ORVi1CWExr2vq2mnN9ffMOuq2r/IASG/h/7ryFCJYYfDQbqrEGHjVz9yThC3UNrVH YdYuryU95nX/BFwLKReRF/6BuA1enF5FRYppmlLUhp75i2i83UTRTzvou7YyvCUxN4ep nCWqG5v8CRFHTAL2Fth2h4bGlbokHp0SDZkmr7uSjXwnFlRrOyDeou6ibNTkWJvqSjhB XKNg== X-Forwarded-Encrypted: i=1; AJvYcCVxqdRbI6YTOa+mCokLPG4Qslc1CeRh+9VK9+XUtlywtws6ZVTAfs46LGPLfS9Nho9dKcCo69MEJ0R6cIaH@lists.postgresql.org X-Gm-Message-State: AOJu0YyJWjihFguQbQotCHyZfD4HG0TElWIFjocCEjPHnfOolpthP1Xf 6aJNSuVFy1jLgggM48nW7OTvu+LtAwNlLgxgtw+9yBI57RJ7RFMHH6jDywLH4Q== X-Gm-Gg: ASbGnctkJl9v1U2ZzcR1NJhfdwm0BIbnO5hdToRTNIkQFmQwc8Z0/lWjXrkIlO3vMX6 T60FOBuVKY4XqEnuEpRwZRf2iTdR8/GUYZj3VaTQi7u4sUPpQzUVb9250t0P9Em8Wa9OkKPCbkx E4NukVc8FZkE14/JRvsXy7Ne25zQuYBkVOFNLXuya7DI/1m5L/C7tsidASmuvK9ae2ok5BWWnzy nFFrd0Lnm9qXUVRYIIT2gezIgA5xi5rs1GLRqnsw5tucUYqCfxW6V5cywSPPBeiieL8i1CVZt2I XiWfDdHD12Li6cRHwoEGkwgDugphooYICee6l8MxrvQ5acETEA1eB7iwsHBmqQFyKlXSg2XGX45 tS+GGQTJ3BBOA8w== X-Google-Smtp-Source: AGHT+IH9tT5GxDgrtwBO/YUItP0zDyBhbuQ7lvcbe3AbmWaiNKl1wute+hqhusGoCYYfZZsM2Umhpg== X-Received: by 2002:a17:90b:4d0d:b0:2fb:fe21:4841 with SMTP id 98e67ed59e1d1-3051c88e52bmr21603016a91.8.1743458647938; Mon, 31 Mar 2025 15:04:07 -0700 (PDT) Received: from ?IPv6:2601:642:4c01:4837:d2c1:b907:1469:ad52? ([2601:642:4c01:4837:d2c1:b907:1469:ad52]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-3039f6b7020sm10117991a91.46.2025.03.31.15.04.06 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 31 Mar 2025 15:04:07 -0700 (PDT) Message-ID: Subject: Re: Statistics Import and Export From: Jeff Davis To: Robert Haas , Greg Sabino Mullane Cc: Ashutosh Bapat , Corey Huinker , Andres Freund , Tom Lane , Michael Paquier , Nathan Bossart , Bruce Momjian , Matthias van de Meent , Magnus Hagander , Stephen Frost , Peter Smith , PostgreSQL Hackers , alvherre@alvh.no-ip.org, jian he Date: Mon, 31 Mar 2025 15:04:05 -0700 In-Reply-To: References: <97b451228227c555be1a4f79c4a62ddec9a74f06.camel@j-davis.com> <1457469.1740419458@sss.pgh.pa.us> <8d13e4296408c53a93390525d0bcb906cbd13df4.camel@j-davis.com> <768b2a237e892bf1334bdcbb066cdc1bd1368cb2.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, 2025-03-31 at 13:39 -0400, Robert Haas wrote: > +1. I think I said this before, but I don't think it's correct to > regard the statistics as part of the database. It's great for > pg_upgrade to preserve them, but I think doing so for a regular dump > should be opt-in. I'm confused about the timing of this message -- we already have an Open Item for 18 to make this decision. After commit bde2fb797a, changing the default is a one-line change, so there's no technical problem. I thought the general plan was to decide during beta. Would you like to make the decision now for some reason? Regards, Jeff Davis