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 1tnP18-004yXX-Pf for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Feb 2025 21:32:35 +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 1tnP17-00ErH9-Pn for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Feb 2025 21:32:33 +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 1tnP17-00ErH1-Fl for pgsql-hackers@lists.postgresql.org; Wed, 26 Feb 2025 21:32:33 +0000 Received: from mail-pl1-x62e.google.com ([2607:f8b0:4864:20::62e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tnP14-000Gjz-2Q for pgsql-hackers@lists.postgresql.org; Wed, 26 Feb 2025 21:32:33 +0000 Received: by mail-pl1-x62e.google.com with SMTP id d9443c01a7336-22349bb8605so4521885ad.0 for ; Wed, 26 Feb 2025 13:32:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1740605549; x=1741210349; 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=XXQgw51vPteiEsRL5jPbvmae/CrA0nm5CXLAXKhyazk=; b=SC2vtB5HW/ebXw1y0FP3rVt/qT2eznol4sQ9se7RgIY9eucW7ZCCl36L/bs2pJ4XeM isQF6D3Q/4mqMZ4Z0GgaQg9toc7sf1ahOurnJHCw4mE5twXC2HGFXcv3iDc2y5YSgLc3 +QIEuhhV3blkocWMPMtJyF9pxCYsLtMBvDiRRL8QM1nHa6wZW+d7pf+3+JsL1WbFdKyz kuQ931NJagkx7WKyWiD4pmhjboaOpQ0SOWmJo2HjdFm7VZtL4AqE4aaxzAIXwCkMTgr6 20bj839sBs0VMb84Rng8Lc+OA4uJRae6G0RIb94qGLzxMp9YTGfAaLRA3mmsm3np14LY wkMQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740605549; x=1741210349; 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=XXQgw51vPteiEsRL5jPbvmae/CrA0nm5CXLAXKhyazk=; b=mw+4WqTEt3lbwYFChP8yXAfeHh6VwB4nhuP7xRlxgcYKA7mJKcvbTOWfAlprZD2nvN 5cXeUNALIbLez1wBXx+jwZoJHyXJy3IrgF6Z5M+SMVfwvnA5fHwKuT97owE4s/7UDKIt QkaMh7jO/eN3OMV7sxdphKl10oylTQfsfS3LzPxZGI31qKe7N3mL6JxCZ9IaSuxbbkV4 Jdnb8ri+X1abOqXJOrm+GMHgNlzsNFjRgGu4/cHDEuRLn+/gfZu2hBBA1e1nTew1f7Gy M9WNEUf/cIqPV6ipJ7uWBL+I2kxZR69xlqkzVM9CFUWwQ0tOUZmtHFJxqhQ4TN2zoL9R sYZA== X-Forwarded-Encrypted: i=1; AJvYcCVxQZmiQ6GmoxeDAjCOFjizmxApMneAAoCqTaef54nRfnls7bib1QYc0CnLaqtVmTsW6E4WuxgzvM3h8tr+@lists.postgresql.org X-Gm-Message-State: AOJu0YyyyR3S0C4ZULTuzSWRroWCystZpVxQUTlXQxPx/ugFop8zfL5j yI+nGhKEp2QAflpW5ACSz8pBv2/z42onb9GqlxxbmfU8Z4YYBNHcjOe9n4GvCg== X-Gm-Gg: ASbGncuMXIkqx2El7BRyUBXcLLJh3Wx8M29iT4avjUbw25YuJw9UNPaEzG7lHg4kLG3 PBQrNYe+EguJ3026xizUrbUkDf/iJyfHiiJg1M/4U74JiO9bR5Jr6DmfXF7ECz2g6Gghk5AgqAs FvD2TIlIqUhHmY1FioTo/ih9lYa/mRNzvKtYUxz2o76OuTKbgVe7CpTWYsQ8AgtMsNdV5n2nCYN uz4Unp7tK9TMKm+vKHN/ZLCxtOJLBpCLGwq3QssW4jrH9o4hDtZMOHY1XzQFi1RkxElkghKbAfl CQyIv8uh040zUN7H/VAd6xiQzQ== X-Google-Smtp-Source: AGHT+IFP+PuOSyCGGjbjTe8zk6jNgnD7Bylx6QwHRxzn5MhjQMRgeyp0G+89BcdIL38m9XfNFZMH5Q== X-Received: by 2002:a05:6a20:7f9a:b0:1ee:e30c:68d8 with SMTP id adf61e73a8af0-1f0fc12b58cmr14886249637.12.1740605549021; Wed, 26 Feb 2025 13:32:29 -0800 (PST) Received: from [172.18.4.26] ([12.126.244.130]) by smtp.gmail.com with ESMTPSA id 41be03b00d2f7-aeda8181c5bsm3743347a12.36.2025.02.26.13.32.27 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 26 Feb 2025 13:32:28 -0800 (PST) Message-ID: Subject: Re: Statistics Import and Export From: Jeff Davis To: Robert Haas Cc: Andres Freund , Corey Huinker , Tom Lane , Michael Paquier , jian he , Nathan Bossart , Bruce Momjian , Matthias van de Meent , Magnus Hagander , Stephen Frost , Ashutosh Bapat , Peter Smith , PostgreSQL Hackers , alvherre@alvh.no-ip.org Date: Wed, 26 Feb 2025 13:32:26 -0800 In-Reply-To: References: <3728741.1740178078@sss.pgh.pa.us> <97b451228227c555be1a4f79c4a62ddec9a74f06.camel@j-davis.com> <1457469.1740419458@sss.pgh.pa.us> <6cac9c19fd64d5a2bd8ecd794ce9e84e9998b814.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 Wed, 2025-02-26 at 15:57 -0500, Robert Haas wrote: > If you feel it can be done without breaking anything else, > or you have a way to repair the breakage, I'd definitely be > interested > in hearing more about that. That would be a separate thread, but it's good to know that there is a general consensus that we don't want to use in-place updates for non- critical things like stats (and perhaps eliminate them entirely). In other words, the inconcistency likely won't last forever. Regards, Jeff Davis