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 1tqFWY-001qyP-7V for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Mar 2025 18:00:46 +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 1tqFVX-002WvR-9w for pgsql-hackers@arkaria.postgresql.org; Thu, 06 Mar 2025 17:59:43 +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 1tqFVW-002Wst-SW for pgsql-hackers@lists.postgresql.org; Thu, 06 Mar 2025 17:59:43 +0000 Received: from mail-pl1-x630.google.com ([2607:f8b0:4864:20::630]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tqFVU-001LUk-1N for pgsql-hackers@lists.postgresql.org; Thu, 06 Mar 2025 17:59:41 +0000 Received: by mail-pl1-x630.google.com with SMTP id d9443c01a7336-22423adf751so8788275ad.2 for ; Thu, 06 Mar 2025 09:59:40 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1741283979; x=1741888779; 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=YLMbUqDv66cXy1SDpHKOA0kPhaqMLNrvVrGWMcBO4os=; b=ubdmuu5S7kBzC6JVHGx3py2hBD+Lk6R7/uvYKhcLYVTXmGJtQj55HUNImN7Dw3PWzX 2Jv5fAePfa1DLkkDnk/8Ke/NMjqlXHWndDDDhUTk+Hiccp4vd0TJRY4rd+MoDV+HrPCi EPQ11uM9ZQ3fgPoOBwrQUewFVUJ05VPMxF0V+LugWPV9/kiAfMVV2mU8AX53GgX9QR2y IWaF+VhqbnqtGuy4QYparVWcrFh5fde+iIFAQC9bfV9mmV+aiguhz7Ab3/qzvD3uqp0d XgrImFBWSOn5Mb4P5dn4W0bXyGfP6joav8Cwg3lOSqlB1BuFxOnCGjc5CLmEByPVePWl 5qgQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741283979; x=1741888779; 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=YLMbUqDv66cXy1SDpHKOA0kPhaqMLNrvVrGWMcBO4os=; b=mNJGvwyrMYc9TIynkW8dUNxbQx/Mu4afbTUxqRQ60dKAhLH4Kzp3sP8s/Rtg/yv0C3 A19132htg00ZLnQZU58C5Abh4UMiEXansdoRWSSKYfoXAe4Fr2svg9xN5LB29tVElSJB akNHSPG0IkcVAtvopQogH5T0qFJK22NcCcmy9iA5EuSIyNJW9zzRpFq7M7x1j/iyHbas A1M8ezXSu4fq63lqM9Va1OcyNbxyeKwyWzFbRTIjmcSw4q8s6Myjdm1A+VcyFsuKN82q Rpver4yXWwmvOpgO3NuzFM17vmxSYLe2jh7JeENU4bqfZNJ8KyrvMGRmGOOyYkYl3zO1 gOJA== X-Forwarded-Encrypted: i=1; AJvYcCX68XLRCmo7xTpABRZmLQ4YSf/t9lDpKrZkoXuQSSzeEzzEL8NC9S5NcO0w3UAIR3XHowsmAbVKCIZXur7f@lists.postgresql.org X-Gm-Message-State: AOJu0YwbzRq3304ao0q5n04KNvMb+qb5G4kdtugiYaTPnr2Bs1UWl845 aBiU/emCfZRuKrRvFLXSlQ8eYvvi7XzvAI79dMkQA2WJVnm0NCwAI5lUifvHMg== X-Gm-Gg: ASbGncvRUVkmGeT9+ta5LxiKcSHA20GPJ25Kf9fisg6R6OBL5tl748KJIclCBuxm+Br e1krn6f81ttVC+pwGS0hrmNPHk+nghoiDD3cDC3Wjq/bdwSSp69LFQlb1Vgt7cbjn52QlteGeOk OJcAXc2SRjkzlrbmfx/mn6nim4KCbnge63JqfUpmbac+qryLJ8c5vVTWN9LSJIfMx+eWvBLfq2P 8VAFu677qtI66EbiGqg+Dl2DJ6gl8QxDyJsNwHehQs2ily/8gGDjAc5wes5qResMwbkA9HQpZXy WOicBiY/AoiCcqgO8zY1ustK057RGek3UOlJviXO1T46mAHqAvh0EYc4WN54odOSK5J3fcLtkW8 HP24vNTDDQEw= X-Google-Smtp-Source: AGHT+IFn39Za+CmklGmHoleyhf/df8yQb73le1VqGJyw3DBfnKuuf98TDG2BQRPVjxU7XM42ciuS2Q== X-Received: by 2002:a17:90b:380e:b0:2ee:d824:b559 with SMTP id 98e67ed59e1d1-2ff7cefbcbamr262211a91.28.1741283978878; Thu, 06 Mar 2025 09:59:38 -0800 (PST) Received: from jeff-laptop.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id 98e67ed59e1d1-2ff693f991fsm1723674a91.48.2025.03.06.09.59.35 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 06 Mar 2025 09:59:38 -0800 (PST) Message-ID: Subject: Re: Statistics Import and Export From: Jeff Davis To: Corey Huinker , Robert Haas Cc: Andres Freund , Nathan Bossart , Tom Lane , Michael Paquier , jian he , Bruce Momjian , Matthias van de Meent , Magnus Hagander , Stephen Frost , Ashutosh Bapat , Peter Smith , PostgreSQL Hackers , alvherre@alvh.no-ip.org Date: Thu, 06 Mar 2025 09:59:34 -0800 In-Reply-To: References: <6af48508a32499a8be3398cafffd29fb6188c44b.camel@j-davis.com> <6rpmhyrtci4epuzay7y5xvd2cwdwb6zmtt6ofxrvakyawxhm7s@6grajbpr4kij> 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 Thu, 2025-03-06 at 12:16 -0500, Corey Huinker wrote: >=20 > I'm strongly in favor of the choice to make it default. This is > reducing the impact of a post-upgrade There are potentially two different defaults: pg_dump and pg_upgrade. In any case, let's see what improvements we can make to memory usage and performance, and take it from there. Regards, Jeff Davis