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 1rrLuM-0006FY-27 for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Apr 2024 17:57:22 +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 1rrLtM-000SDs-Hu for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Apr 2024 17:56:21 +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 1rrLtM-000SDk-8Y for pgsql-hackers@lists.postgresql.org; Mon, 01 Apr 2024 17:56:20 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rrLtK-0000XN-LX for pgsql-hackers@lists.postgresql.org; Mon, 01 Apr 2024 17:56:19 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 431HuDAg1140247; Mon, 1 Apr 2024 13:56:13 -0400 From: Tom Lane To: Jeff Davis cc: Bruce Momjian , Corey Huinker , Magnus Hagander , Stephen Frost , Ashutosh Bapat , Matthias van de Meent , Peter Smith , PostgreSQL Hackers , Tomas Vondra Subject: Re: Statistics Import and Export In-reply-to: <42100b1cd67d2b690e5da611ba68de64ea09a62d.camel@j-davis.com> References: <718fa933c2c58d0ecc61995ab5c7ca1fe78d6369.camel@j-davis.com> <790773.1711910899@sss.pgh.pa.us> <864345.1711932452@sss.pgh.pa.us> <1043793.1711984209@sss.pgh.pa.us> <42100b1cd67d2b690e5da611ba68de64ea09a62d.camel@j-davis.com> Comments: In-reply-to Jeff Davis message dated "Mon, 01 Apr 2024 10:31:03 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1140245.1711994173.1@sss.pgh.pa.us> Date: Mon, 01 Apr 2024 13:56:13 -0400 Message-ID: <1140246.1711994173@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Jeff Davis writes: > On Mon, 2024-04-01 at 13:11 -0400, Bruce Momjian wrote: >> Reality check --- are we still targeting this feature for PG 17? > I see a few useful pieces here: > 1. Support import of statistics (i.e. > pg_set_{relation|attribute}_stats()). > 2. Support pg_dump of stats > 3. Support pg_upgrade with stats > It's possible that not all of them make it, but let's not dismiss the > entire feature yet. The unresolved questions largely have to do with the interactions between these pieces. I think we would seriously regret setting any one of them in stone before all three are ready to go. regards, tom lane