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 1uFFQY-0026UV-F4 for pgsql-novice@arkaria.postgresql.org; Wed, 14 May 2025 16:57:54 +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 1uFFQX-00ATRM-71 for pgsql-novice@arkaria.postgresql.org; Wed, 14 May 2025 16:57:53 +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 1uFFQW-00ATRD-Um for pgsql-novice@lists.postgresql.org; Wed, 14 May 2025 16:57:52 +0000 Received: from mout.gmx.net ([212.227.17.21]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uFFQU-001tBM-11 for pgsql-novice@lists.postgresql.org; Wed, 14 May 2025 16:57:52 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.com; s=s31663417; t=1747241869; x=1747846669; i=lazyvirus@gmx.com; bh=AzvMk+nbgx9/yNlmVH76/Uan1CE5KvUrsKLq9TOesuE=; h=X-UI-Sender-Class:Date:From:To:Subject:Message-ID:In-Reply-To: References:Content-Type:Content-Transfer-Encoding:cc: content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=NEBnP4syPI0ootWgKQdi7lEExNkK23zJap+VFZD25A0GKnFtPQWl5P/3PdNh+Qug VhKrYdZGopL6LhagRLWnnTOO11SZEEGAmsFOi4jSPpj2AGfNwR0/FFWF9kFclsTqG PFIQoLnOQb2uapNe3avsNBicFcxyad7UFsZgsLHelzeORLZeGSLflHL+r5QEymCQJ xY0n5LosrITrIMyde8wdvcU3P9Kr9wu3tE6MymNf0+9AqoGCq5vLHS1I5E0VDFfbk giuj2knvQgff1EbE2Ay6m8mn0/J4rYltheV2zvs7MA1wWE70QQSP32I8feWc9awTW qZRetA1BOp/LaeLXXQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from mail.defcon1.lan ([93.15.31.113]) by mail.gmx.net (mrgmx104 [212.227.17.174]) with ESMTPSA (Nemesis) id 1M4axq-1uEhSd2YVC-008Yo7 for ; Wed, 14 May 2025 18:57:49 +0200 Date: Wed, 14 May 2025 18:57:47 +0200 From: Bzzzz To: pgsql-novice@lists.postgresql.org Subject: Re: Fillfactor question Message-ID: <20250514185747.3d1fb16e@msi> In-Reply-To: References: <20250514112913.416cfc8f@msi> Organization: Anyone, anywhere but in banana demokratik republik of france or uerSS. Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:oSIMaouuA0TAAZPTIqcFdJEaCHX7/mrfzF0OBVabDF7QlYYe7h/ H/fhjzxQcYD1l9xZb9vzXaP+0NS1XgA60cw33fxiL9AecnuRJ7Vlq/xF9Z55fJmbGqGyt8m XU8QTFdp0JHrkwqvtW8nw/OEWmLsXkrT7iIAKV0gEIIw3ug/oMgEHQlnBsnjvDqICx8qzB3 84Y7w1bEulDSR90UfFFbQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:bBgO6bkaTIw=;dH8XE+Pe2Qi3U2kyKkVtBjEsyTL 8080pNaV67s2PlX6tjRsoWruMYdFLQz2QVqI/bW+9LajH9mvILqBqsUneSTEd2/mIhurHHKI9 S1jrG9VhAxvQXo6Ar9MZMMgP9kN0xnNOgXFka2qC+WHOyMqaxQVZDaSQhqqeX9Pv9VC240uz4 OiXYco6dSwO6AKSVG/MLXFnR44ICfZW0Nkcja3YRoXzFphayZWTUP9NO2zP/b8k/PdvSgrJmA Oz9LJbtiVEhblFrAtL4qzBIJZfx22IOF8x+6smi+nV5eeXH040C5/9153qL3TFvrMGX8gAl2z Hwoq+IGEXdbV3OQDnRLf7t3qfFWfH6/s1WdVyfEgjQo7ovLfy2Ad/LHlj7klfmCxY83nWAG/g +jRpwEjT+SYf0UCxduCL1VPLi8NNNpEBiip92iHMnHHRo+lTunHlIEX3DjjQy1w8trotNwB2g xjuQ4NMyV0Jkx87zhNroxkCoMhygepzboW4YqqBmCNkq1sdVHoJ8JylyQu/7UbfmsC0aaNP1+ dbQrpNrh4w3mO8T9PfrLfvYQfr/4HPzBIQJ0+czwBHHeSFOlpJ04hnV0+AzcC7uJsgS2XOKF9 j8ZQ7RB/k17cI24nPsfpVoEeV9LUeI4GFtIZmSDGmOc7ShyE5xGQFoDqCu6E/dMfqTuUNgu2N bV5otUcpSoiiVlVv/ddmIpvtlAGZwRroeE1we6veSg4ISAMJ0QExBAsLGLCEZFI+DX2mTf55R MO8RuIigENQZV4f37itirbf5e6DYAbvI5lvWSjOzmEGtdiAVdhuwHBSr2JXjMd0h+tcTxoo0D 0FUsUsqOllfrsfqexeOUxuU/MTAezfxgHynRm2Q+8vNpA0TqV+IoYOT+0v3giz3Pp67Dq6vBa 5UuxfpcjxOWw6aDGz4Pqv/ZRb/QBR8drUOXKmOcqfr8xFWrOL938KuwCH9sRWqnQkMBZoclbd EWxt470ZJxH4od1W/7rMFQ5UGYRi6vA5xYgj4ArMpf2gPC7C+d2qLkj4l20Tw9NtFs86sCe6D I7Yo9QKg3WU/ZTybKpwQDULXWEaX0Pk0jLOwXhjk0JcMv7gYPE5CMaPt2dXCnp1QjmL4R9SW+ Mmz2D8Gw8hYWXRN4K/IHc2L1BDQijU+k45orQ1X+ikVVopvBJoiLRzctaYOZBRP9ZJSlkcag7 SnjbXiunkUV1adrgwN+xgu6fs1FjeAt5pthl21ByNVb76MxbGNQIubF3WvChuo6hn9vggbIGe cvFSPrBssolEwxGX2bFkCvgu+WDyHsNuwAQq9c6W9YwwU6CXV12MB4MQmLBOioQ12GQmPw7ry EEZt3qzuqe0mNSgpCm3XI5PwHOKWJS+76y6ydGCKXmGZY/Iwtabej8bFs4ke/LjmswTvdanlO G/t1J9s+nVJgV77h4pO3B0YH6av9451936cLqSCEhAGHS3vHJSxUwLs9usGkjT1qajVdtvA3h q7UfvBMf63mdUIExNDUlYNKej8o1NzAkcvfsydyjoKnh9luWVgbYxpnvgdJPAD9v4VRnXexm2 /XH6K3NyWfOjXM8gW7MmUGQbmTRS400qblNXrafV9x3HZ9JvSgBKYIPivzlqonTWG662oKYLs Py4OKke88qRbfdaHdRZGqDFw8+xUC1yTk5xwPaiNX4tfIrS1E0O1I92e2DMJ09aX2a64mSP5/ xUbPXGtXuxuKlvtpvhxvbLWzawSsnzck2Nveyi+nT1pxzHq89EDH3vaiZqtTzQ7JcTxmQxGZw e2L6TRY/x37r6GRcUCrUYc1i5ORXRqBLONBeRaf9/1OvPphfc1Q8ByXIBMUuaYvPH8kJBnXtg hZxWKj3EhWAgNomFpBjfaroOe5R7Bzl6KbSs9N1sJJhTwTHPxMmOw2AhUf+NoBUZbfT/Vp/Ju Dnss9y1o6ETMP86WyRGZsUXvkKPXfsP3gD7eMX9gQNArCvD5fixy4q9wgs2a5R95B133BBCBR JKkdPcHdSc9sx4BWxaYSDrfhCzLcg7uHkUGE8AzRN/mN2vhNzjqlk3N/MHixF/iAha9SsfYsN GbMMYasuOJktSUBj8FFC5kihL2xA7bKSbrN1Tl7nBSo0bl0BEJ3bvH802GyUePIAI2hvp6Phc j+tW2w+LviK5nuohfS8fNcGY1jHRCg66ZXg6UGWT3aOdXTVu30VhbhqYAfjAkyJqkGPVim/DI 6IWxR78uHhp7EkGLVj6SiCq9zA5Sq9HwUEalDs6YtyzjO1h8Dlj2PTUOtl/5MfBzysdX8hDoG EQ4Mi82wFa5gkYaV81xgFu1rYgg0qNaWUym8n01dABvyzpx7HBcTSQAbXhIThWT7J/Zt/fZSI YBQ212dAZTpKScT0wpkF+C30XeDeMRdV5uSMptZ5+6TLFPvv1JsRtWRo5WWCaZ2SI9OOgnLsv BOH9rd9qklwxIl0LHf/OEaBoRiFDi+VCBx+/Nh+yVt028sNG5jpB/FjAn/7zxXzVLthfTxn/U f4G7G0LSOllBobmNVoUWOoN2YPzgjJrkHp7p48enMIK5FOACR+VHLoXJs6VGQLRMuaM/IPafz dvYsbcEK+WbYMfotjEeUd2Q5skYwbBfO5Hx4uqyv2+l9oMqtR8Nopu3y1cyOP9GXXIL40xQhT mhMuRdP8MOw4BU58fPMI+c0875qi8avxbHjjjqnA5WEZG00NeGMplZEHqNhulSuMYV58LbryE qmkNpwcfhfJy5itxALQG6x4RnEnCXaydNBCo3iCui92Sw19MIC0xLHtZdczL6hICPVLsGKlDw gqMomHP2vkUuvHQGc+87Bm6gablsksFg9Us2iRMskaeuP3YpPw0SgryCnLr7jiBSAaywWHHbs +SCeIJsiC+tuNqGqbsfi2kLn0cJpBBhPdp4qyKrt3+8H7qDw9yduIqo/dCvkCcXU+aKJEe2Dc Y+wrYJ41TQ7x1LWEID3ptlmpYdmv3L4mAkGByF0GqrdjAh17rwXAjofVZ2Hpglc0h51fMBqZm as7nPKYqu1DEmokUkQwYW92olDyUnNA0nFiO6VCsb4eK3PXNmGL69+58wR0VwAn2XoW+esSco wEKrdJXQo4vToJuRJS42Tozxk7bcrCnDOVvqPcgJEajarX8Z53s4QHcDys4wXIzKQ== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 14 May 2025 12:42:31 -0400 Greg Sabino Mullane wrote: > On Wed, May 14, 2025 at 5:29=E2=80=AFAM Bzzzz wrote: >=20 > > does creating a table with fillfactor=3D75 automatically propagate to > > its indexes or am I obliged to also modify their fillfactor > > accordingly ? > > >=20 > They are separate, so you will need to modify both. OK, too bad indexes fillfactor do not follow the one of their table by default :/ Thanks, Greg. Jean-Yves --=20