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 1tnOBC-004rBI-JH for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Feb 2025 20:38:55 +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 1tnOAC-00Dg3N-Tc for pgsql-hackers@arkaria.postgresql.org; Wed, 26 Feb 2025 20:37:52 +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 1tnOAC-00Dg1Z-7d for pgsql-hackers@lists.postgresql.org; Wed, 26 Feb 2025 20:37:52 +0000 Received: from mail-pl1-x635.google.com ([2607:f8b0:4864:20::635]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tnOA8-000FUO-2g for pgsql-hackers@lists.postgresql.org; Wed, 26 Feb 2025 20:37:51 +0000 Received: by mail-pl1-x635.google.com with SMTP id d9443c01a7336-220e6028214so3946105ad.0 for ; Wed, 26 Feb 2025 12:37:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1740602269; x=1741207069; 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=691dRvIr0xxaBsv6zEgMIO45pJ0l/ffiRObsnvY3NJQ=; b=LeBRw1Uqu+qifyovnjLFwFO9D4IyL3MkYAdenD1QMYr0GgmEu0hJ0P93iePKlJnAmh Sc+pkX0F4AATJt18HJ/aj/FH8Fc/ftC2TE2fHnN2SSxucYdMmPJ3yXgZXgHuzhsuKO61 jd1z86tiebT8XaADIpzxba9vvj8CpdsV3AsogBaZSEqRAfscXM5f7vbwriFzQuegigBl nVL+VGmLwxrSSp3D+74Z81s/zRSPHjtpPjHLgJD7+2auv5GmZ1ditmyN9SwAzn572aGJ AW+LP5F2b35+QFn6Ukml0jtx/BXHBEuZ5j6wu+Ulwsa1E2PGJ5h2+ghexdEbazsoWVm+ IHwg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1740602269; x=1741207069; 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=691dRvIr0xxaBsv6zEgMIO45pJ0l/ffiRObsnvY3NJQ=; b=Sl5Fk41EXiUqhyyyDJrVDU/xmB3wwK+SGseaD5BkRghFVzScNWnqWdOfAp9TSy1sNF qPi33tAh4H40UjeubIUsPyWIdCPUbEgAgVTd5F44CKEyvp4Vk83sou10kYKpxz7AmcwR uakrbgwUXomdDvrQoon2dQAiSLATlbDoSW+eE444f55vJA8iSrfCtJl9iIvJYBkiMFr9 X5TAQtg8aR3BvPOC/wdjYo7Je8mFz438EjyaM4+nURgOJz8EcAdFeguVmKpmLAnIl4c/ icSlVOVega/j9RRjEshhsYqHNWVTdOcHYOjmL0bVsJHPO426QLszPJogqjPQpwvTH/yI CiDw== X-Forwarded-Encrypted: i=1; AJvYcCX/MBN1DO3Znv3bM1mkSqntRpIxG0TrxalPkkJeSTK4jOF0Ixgq1QjmfzOy/M0/yZhkJSmUSC3fQI6h0d+0@lists.postgresql.org X-Gm-Message-State: AOJu0YyDoqsQA7Ttc2NqPYN5K9UEr0qvIQAicPHnY3sptVNj1h4z/FWp lXKYASPNpG0FnyO3jjn8P5ZN4L54HFUkUDQuboJQE8qdJ1YrYB1A1/46amDIcA== X-Gm-Gg: ASbGncvD/33Af3yjHfCjkLBTdhw8wWG0G58Qt7CpEPE+2NASHabGdqVGFziYyGQ7eFE BvKReAj7CUz1jL0Q7MI7XqNDOs6qvLUoxnt4vwKh/YIzg7em3ijL4M8cQjVgxQGFaudfepkSfPQ 2BIGvrTIYnFlaVdOvfg7UO8kAVOKxh5SKVK0D94XC1Pfuhcjf6X/29cbcCtY7QP+HU/8M2aSlS6 mVL3xQuep6qpUhvrR7Hjw1tkRb9zH+YibShQV/18ikGnicRyNPAZuLEnIz7xoYqtr5MRc0SRoP4 3c1zFHXdX9Z1j0RSN4hpaXYg7A== X-Google-Smtp-Source: AGHT+IF65fWoGWw4a+PMJM4Va0TtUKYRUxCQUfyEATrOXQbEo3CFTiGijjDf8gOetepoWGkocqsRVg== X-Received: by 2002:a05:6a20:2591:b0:1ee:b8bc:3d2e with SMTP id adf61e73a8af0-1eef3c55d28mr44000003637.8.1740602268952; Wed, 26 Feb 2025 12:37:48 -0800 (PST) Received: from [172.18.4.26] ([12.126.244.130]) by smtp.gmail.com with ESMTPSA id 41be03b00d2f7-aedaab2e9casm3648916a12.67.2025.02.26.12.37.47 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 26 Feb 2025 12:37:48 -0800 (PST) Message-ID: <6cac9c19fd64d5a2bd8ecd794ce9e84e9998b814.camel@j-davis.com> Subject: Re: Statistics Import and Export From: Jeff Davis To: Robert Haas , Andres Freund Cc: 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 12:37:47 -0800 In-Reply-To: References: <3728741.1740178078@sss.pgh.pa.us> <97b451228227c555be1a4f79c4a62ddec9a74f06.camel@j-davis.com> <1457469.1740419458@sss.pgh.pa.us> 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:15 -0500, Robert Haas wrote: > I strongly agree. I think shipping this feature in any form that uses > in-place updates is a bad idea. Removed already in commit f3dae2ae58. The reason they were added was mostly for consistency with ANALYZE, and (at least for me) secondarily about churn on pg_class. The bloat was never terrible. With that in mind, should we remove the in-place updates from ANALYZE as well? Regards, Jeff Davis