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 1tAyGk-001DCx-JW for pgsql-hackers@arkaria.postgresql.org; Tue, 12 Nov 2024 21:17:49 +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 1tAyGh-009ToF-T1 for pgsql-hackers@arkaria.postgresql.org; Tue, 12 Nov 2024 21:17:48 +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 1tAyGh-009Tny-Id for pgsql-hackers@lists.postgresql.org; Tue, 12 Nov 2024 21:17:48 +0000 Received: from lahtoruutu.iki.fi ([2a0b:5c81:1c1::37]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tAyGe-001bNn-8C for pgsql-hackers@lists.postgresql.org; Tue, 12 Nov 2024 21:17:47 +0000 Received: from [192.168.1.110] (dsl-hkibng22-50ddb7-241.dhcp.inet.fi [80.221.183.241]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: hlinnaka) by lahtoruutu.iki.fi (Postfix) with ESMTPSA id 4XnzlW4rz8z49Q5g; Tue, 12 Nov 2024 23:17:43 +0200 (EET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=lahtoruutu; t=1731446264; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=DAak4aLDX5F46MGaLSiS9jcSWBWHrDHrlqI5//Lq46I=; b=Dc8Lynzef7DwKVdAqFc7VIJq7vUK+FxkHQGtAa/8042Pq+lYgKDqTam7vxYYd1GH38YXgh A3VZ7NckhxVsmeZvPvbhMfHe6j37tK+jkpa8o9XbfbQME0cPV6uDglTryoTBX5h2W4jnhI vwtL+x7IxMAGff/Tlnd10nsARx8rz6yZAAKeUoxdG6XLZcvMQtvs8rhXTBsydaXS9vHlHz Ezg7/ayHOalXQ1Fr2/AuwxRQ4ElXj66SdYGmW4vBjqjgB1UrpYowks3Z0JZOOp4inWohXO vi92xayD1oYJxyVd8ikips+IR+6LZWRztJfIGrTTGj6nonDnp7otoi1X3SbTFQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=iki.fi; s=lahtoruutu; t=1731446264; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=DAak4aLDX5F46MGaLSiS9jcSWBWHrDHrlqI5//Lq46I=; b=jQh/n04PkZ8lfs8flUAVXk9WLNIX7yNQqpM90Buc6agdy4LXz1/JPgPcy3ewJPEtEr1JAy lupC/DOzESAifYiEmFj3rzW0j8qtJ0JXMJzKRrQfDAbW9UgOB6ZoZYb5vcaTr8MNJgfE4x vJmhsdwgOsVOh1KL6OxZ6V1LMdQRvAkCbR++yODEgiD61Yo1kkr/NAjsL1fg5YgrhFxXPk 1VIBPgEJ89N/LL/rIFB2O+gFxJYs76QMOUkmHrowNzlcE1pD6ZOu55PWbcCvHKsAmd0LXG y9uO7spqccqjGo/KospLdei3iDMvJEwS00T2sbFdJ3+bFDaDpzDZshxSxbQ0wQ== ARC-Seal: i=1; s=lahtoruutu; d=iki.fi; t=1731446264; a=rsa-sha256; cv=none; b=CvxD1Nv1TjzkKRdaDSgsDs0c1/ZubghU8p3LiVM32NWSc7uK6VbwdAd2e3MJvb5Oc9Lag5 OVy0TgjqpaXuTFi5Wx1+B1fo24pF7plyK+Pi7ZxUxM89EoGbqFQAVZ8DTtQsDeBzqBGSXy KnEBugar0AEUysGv613oGl62PoPUGdNYlkTHDwIur/8gIAWKnz4Db+f9fWNShXFJZ3q2GN vJZ8GiNEaKvPDlD6+qTgicPwB1kDAHZS4wiPWbREArKHXCRPr+U8Uk+AvPL2JfF4MhtpUQ a2hzZFEmhSnkVN6q/zOAvJ4zvw1CDcBCIqGiJxzUY41la05DC1FaqvRqDd9adA== ARC-Authentication-Results: i=1; ORIGINATING; auth=pass smtp.auth=hlinnaka smtp.mailfrom=hlinnaka@iki.fi Message-ID: Date: Tue, 12 Nov 2024 23:17:42 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Statistics Import and Export To: Jeff Davis , Corey Huinker , jian he Cc: Matthias van de Meent , Bruce Momjian , Tom Lane , Nathan Bossart , Magnus Hagander , Stephen Frost , Ashutosh Bapat , Peter Smith , PostgreSQL Hackers , Tomas Vondra , alvherre@alvh.no-ip.org References: <9e068620350f0158e791fc0b9a68df896d4402c6.camel@j-davis.com> <11bb2c7403d4a7421fe8b09df6737aa83976266e.camel@j-davis.com> <556670f6a2e8dc01dc0db89fdeb40660198c2ef8.camel@j-davis.com> Content-Language: en-US From: Heikki Linnakangas In-Reply-To: <556670f6a2e8dc01dc0db89fdeb40660198c2ef8.camel@j-davis.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 23/10/2024 01:27, Jeff Davis wrote: >> I've taken most of Jeff's work, reincorporated it into roughly the >> same patch structure as before, and am posting it now. > > I committed 0001-0004 with significant revision. This just caught my eye: postgres=# select pg_set_attribute_stats('foo', 'xmin', false, 1); pg_set_attribute_stats ------------------------ (1 row) We should probably not allow that, because you cannot ANALYZE system columns: postgres=# analyze foo (xmin); ERROR: column "xmin" of relation "foo" does not exist -- Heikki Linnakangas Neon (https://neon.tech)