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 1uF8QT-000PCB-FJ for pgsql-novice@arkaria.postgresql.org; Wed, 14 May 2025 09:29:21 +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 1uF8QS-009JFR-1s for pgsql-novice@arkaria.postgresql.org; Wed, 14 May 2025 09:29:20 +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 1uF8QR-009JFI-Kt for pgsql-novice@lists.postgresql.org; Wed, 14 May 2025 09:29:19 +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 1uF8QO-001psP-2z for pgsql-novice@lists.postgresql.org; Wed, 14 May 2025 09:29:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.com; s=s31663417; t=1747214956; x=1747819756; i=lazyvirus@gmx.com; bh=DyJ/BwA0yOkaX+ICMd2oiogWWs6KnDMtdcYhhSFML+c=; h=X-UI-Sender-Class:Date:From:To:Subject:Message-ID:Content-Type: Content-Transfer-Encoding:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=Y5FmLWXs1Zr/3/TmMBWy713j+FftFmE9MqoPg5vPOzCXwf06StaTOehhC8wx5Spu V7/yp94TK5Vpnn8iKmJibfyACXBBqFEa09mwBUlCeL8EdrL2Vulb3ng0+fkznO+fq 6CDAgCP2xIyq1LMbTIzV2ao4S4YtMZRP7WfRpP8yHeet7fWxWivcKSOlfqpM1KvpK QyeN4UQGyKRDC2QNds+yJrmKFfeAOt6vV26p9zGvYSYBqlFv5GqenFSQf95Ag053b bxXf/U+P69ruN4x3HWvA1OIJtneE0g4vui/dhNcohBMNEAr1P/BuM6BEFR9FOT0A2 D3WwP7Mosbb8iDzZpQ== 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 1MA7GM-1u93bi15sA-00E2X6 for ; Wed, 14 May 2025 11:29:16 +0200 Date: Wed, 14 May 2025 11:29:13 +0200 From: Bzzzz To: pgsql-novice@lists.postgresql.org Subject: Fillfactor question Message-ID: <20250514112913.416cfc8f@msi> Organization: Anyone, anywhere but in banana demokratik republik of france or uerSS. Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:KxrpbnIX+5rfsF8quNmQzdyBDjxLtr7yZ9rFJROuVO0UM4wD0on pxrwbGnvSGxPY2YGBcZK8CbeP/YsOrfWOjCmBLoJdXgVbbPw1UPxl90xsIZG6WUcHtmwKBC H99H4GgHB0i7HqBlfeHmq8Ukk1CGYBm7vdsIoVXfFSm5YJBVthetHuPpdnbT5Uryuw+zdjb 18g7DDIFe4bfFSECi2jzg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:oUMay+46rf8=;rVSdB4zsmDLbtyio2GZn+J3sbhn rfRYwmUssTsFUwSVxZjdldp2YXNI0JNvrGvZuK8fjYMSDO8cJBt63FYxpPrwzd12+vKJNZddJ o9inc+9tYNXcJsQ/Hqfo/+n+D2hrDpF3VoBkmTuwW2AuJ2sH7QqoFlIn3w3Fifboj6y+v0Lby deUVXnq7lMrEgJONgh//T4JdvVl7OPcENlCvZjbBHK9bNKA5pz/9xXOted7El7UR/EzmOFUuS 650y2OftbLMz3akyLmZZOGHbTsteo1qbp7YnVWHlHLSk7TNvqDku5SPa2SMdCns1m6+ZpWmA7 GogmqJhJllMKFa1zezcVCrbFF9a7NkG1EnRstGWgYENYlpNuPk4HH5YUNXGWGerF/Pbq3/SJa I+KnfoJwNh0EQ1dOi5+lJWR9QpOhksgH18zsOk7iPfCkLdbTiI87Gds6bfxL1zI/fo8EATVg2 jYRo6XYWQ7aSu0xSY0GFajzyXCcJddoJYtp8iZVghjT+LlvwvJnzT9atgbY4NZ5eftUHRolzA uk6dxOOi1tk+nz57T6JNnisYrLBU779UoRDbn3P3dMnMhnHgm9GwjJhBepYHehyBaZzIhux1W eZMjTOXrtQ16lzxxfLyzQW+/7hEKI9+R7SeQxt4wZl61XgTBTbBcaCKgjeOXY5Uw95ImGK1DV 4fak5Vk3JDniwZcgyvzmzyU9OU4rf9+osK1VMt0EMFNZETME9c0mpHGteBcZUEK1nUM7sP85i ag84xLyr2tDibaGNNmMygN5vQ55ArKh+9Tr6HDyWv58B29u1IgBCs0NbuZbVDiSDB4X5kXJU7 +llrHYiBE4hCfnTzPN35Ggq8zkk5k0dABNO5+8HiqPj3CRLcXK4fLB6HHhO+YsJy6p39KoOMk HF5BwroLAe490wZ0eTFxQd9UjdqjnMMwagJXgsEDJwms/a+V5sfI4pYXAlxVXAD+YFox7U5qG xeMNhVEp7SUu+7mr/EUpmKFwHrOfaX6v91YJi8BsXrzXa2F21ZYhemeyWprwh76IdMXi+Jbkn v1uN5LYhMW6pHrjYjg0HTjZHZLxjf/AOSN7rOCv0CQOPkNLBjRaAlI9NVImBW62mBwWjGvXIb NFG2RrXFIJ/gc70RM0hXBX5arWCk1pCOr0ludWDRe0IYXZr3VMcsCBRDBreO72Hc2w6CQnO8E vouFjlceMZEOvW7mPtUFM2ePva/xS2TEvuFWtxwRt6FXuxoZJRk8o3H+6Y/Jo/aItBaS514xj FkRmFqIl8M8E08ObbkCfG7l+nBPcjk4H38EiiUyVjByWF27nQsX+Ux3zOdcbiZuR8uxwGIHFL I2ylgDU7dgKpQJO2qVbMXWJJhxHE9fgudvJfHMCTKWxVezRBg1wajyV+HG1B/W1UScCCmZHWA bZj6gmwzHSju101/wJ0b0kojty1mrtrsf2L5/bwkzgQj74FAm81Rph/sL2+Y6wnYjYpyCJgui /QoUk6ZA6pfCsCJjoZBKXF/dHEA9BqLmyetUQUZC8Ty0s2kyCCx7KbOv16ikDhvxfZZCNsUpp Q+Jxy9d3Z5l5crWzzDt9MVnaP7gn/ND4v8hGrdgvREU4RD7PxZiRFIREriwaBQudeIgJjk/2b X1UbZJsCNVslLZTfD9O+QONOkXomv9mgG6TO18Ls4Mt/kyQBKP6GrAk/m33+rfpTDy8g11J0O XTZRvh7SOYF9kkooJd7ptbG9yAQIlewIpwibQ3WOjfdx6gLM+N6eFTpeYY6WXyCbjArDDA1Vy t2ICtuoAOKznpKsMzw5xqAxorCLvai0bwlQ5YFmQu0UziQBJcOHCJWC/Hm3ouiM1yv5BG4CFf 5uwVRNikPVmGnFMnajsrb+QekfRrPMC6IJ43pYXS7ojjGv1+yXCt5vcliCt9U8IvgVD1pwW+h 1v3BSQiFKMMkqxI0TicCg8Dnl9/GHI8nFoK86wGxgo6cOzQe6sGdKBZRGtLaKCBG9mKvEis1b jLYqNnY0US0mVbwSo92DVfEptliT+5exL8/9LlN/WE4ZDGcetvO0HjHdRWVd0njN+zqdO+CqE tMGFuyGfyWOktA6ddYyOjDV0LHQc8N3VHDMQSIdwG80fWrtrQQCzTBTPuwUYM9WXZ8WjyVJ+7 ziIkiXOOZ1SmF2ZdsGJuxbAJQbCuBjLD4lnRrCFSgdI7jDGLyj22x2hvtLkBLfnXO/3YmutwT qjK0QI4vn14zX3rbmR8dQkWT7idnhwmdFOJNnT8UfX0+ic9amzWb8QlXxJC8AG/AdfjR3/uqc cFR70rC6J75HC1gJUa4x6YdRzuNQdxBcfKlJfcsdwW9y7jEOyqFA2WebJzbiifcHV3nGhzFBG WkzP9X24Hz2OnDmaFVvbngn3FQ2RsTKvTr5d8FMqvmzew7+6xsxSVAZvhPJ2e5KawQqWHQp// +vx8hCBiKminkXE7Kov0Ach4Ob/bK1CDj7iubCXuribR7GAigtOLrrim+pDqxyWJIqY2QHXQn buD3E9wsZUDLI9bVpjeW47xmJGI8qoc2MKqI6FKhMdc8sA3gw9ttK74jpI69YX4qCdTYZXgYv baeCsWGQRRw4lPCQzfVB7npt8SsUNc3dkikIhQ2QGEcfH73dBkqJCDULuq2x2HoePHn7ULoVs IdRtJkaY9xGejO53lQIO7gxF6hI5VKd32b0tFat2wL7EcTNoKPVC8NqmWcPLPxAIla/tNFk1y oyxTRZdhcvl8aeln/RKZsYBo697mT+1d+cBC4f8tLki0Nu/sdSB+HbRSPmwTIRIw2HlVW9KUC qpfQns8IkgMRzeeNE9Lpoi6mdhLnbvif/Z/ldQKKrVJ7+eUj/jgZpDDU9ISTucBFcff6+7G/V qH7khXwyz97sjNKd+wWY9VnaSO1u+BNM6XNYvouTEws2PqZar0YCIQRb3ch6aaE/ocCUIrL+0 RVOTNHqgUs2aZ0mm/SfE7YfuBnK0cALIKywbYCfjYeaydPCc3YX7RveezLPW3Xvm5MyrWnjGT 6Yo52vfLqR9nYC2bRewyw+FR68dv2zgCB0ryeofKCa8PYMu/i3OCsSN8Gk/WujljpzrQ2ohnQ P8VoLKTbpcrZxEVsDsBYUU= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, does creating a table with fillfactor=3D75 automatically propagate to its indexes or am I obliged to also modify their fillfactor accordingly ? Jean-Yves =2D-=20