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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1u97Zl-00FfUZ-75
	for pgsql-general@arkaria.postgresql.org; Sun, 27 Apr 2025 19:22:05 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1u97Zj-00AJe6-6K
	for pgsql-general@arkaria.postgresql.org; Sun, 27 Apr 2025 19:22:04 +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 <xof@thebuild.com>)
	id 1u97Zi-00AJdy-Rm
	for pgsql-general@lists.postgresql.org; Sun, 27 Apr 2025 19:22:03 +0000
Received: from smtp69.iad3b.emailsrvr.com ([146.20.161.69])
	by makus.postgresql.org with esmtps  (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <xof@thebuild.com>)
	id 1u97Zh-002Ftb-2H
	for pgsql-general@postgresql.org;
	Sun, 27 Apr 2025 19:22:02 +0000
X-Auth-ID: xof@thebuild.com
Received: by smtp9.relay.iad3b.emailsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id 13713201B0;
	Sun, 27 Apr 2025 15:22:00 -0400 (EDT)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51.11.1\))
Subject: Re: Changing default fillfactor for the whole database
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <CANzqJaAQCt8gE2dyZ2W6fP-iWiZqykojNipGduds+N=WJuNyRw@mail.gmail.com>
Date: Sun, 27 Apr 2025 12:21:30 -0700
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <042C320E-68B8-453E-A0DF-C1125A50C7A4@thebuild.com>
References: <CAM2F1VMu747bv5X3wTvhzLQUWRaJzREdaS=coVz+WjxkBjzvng@mail.gmail.com>
 <CANzqJaAQCt8gE2dyZ2W6fP-iWiZqykojNipGduds+N=WJuNyRw@mail.gmail.com>
To: Ron Johnson <ronljohnsonjr@gmail.com>
X-Mailer: Apple Mail (2.3776.700.51.11.1)
X-Classification-ID: 6b77c314-8f13-4d44-9dfd-3c1d1b891ef6-1-1
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/042C320E-68B8-453E-A0DF-C1125A50C7A4%40thebuild.com>
Precedence: bulk



> On Apr 27, 2025, at 06:54, Ron Johnson <ronljohnsonjr@gmail.com> =
wrote:
>=20
> I agree with him, though, that this a foot-gun: most table's aren't =
that UPDATE heavy.=20

There is plenty of precedent for GUCs that seem to be useful, but really =
should never be touched except in the case of fairly uncommon workloads. =
 However, that doesn't mean we should add new ones.  :-)=