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.96) (envelope-from ) id 1vpq5k-00HA1f-2u for pgsql-general@arkaria.postgresql.org; Tue, 10 Feb 2026 15:55:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vpq5j-00G2Ic-2n for pgsql-general@arkaria.postgresql.org; Tue, 10 Feb 2026 15:55:55 +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.96) (envelope-from ) id 1vpq5j-00G2IU-1a for pgsql-general@lists.postgresql.org; Tue, 10 Feb 2026 15:55:55 +0000 Received: from mail-ej1-x632.google.com ([2a00:1450:4864:20::632]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vpq5h-00000001T64-2mO0 for pgsql-general@lists.postgresql.org; Tue, 10 Feb 2026 15:55:54 +0000 Received: by mail-ej1-x632.google.com with SMTP id a640c23a62f3a-b8e9c8ada38so961248766b.0 for ; Tue, 10 Feb 2026 07:55:53 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1770738952; cv=none; d=google.com; s=arc-20240605; b=NQ+egrgO6lbphoULDNGxMKgnbqp6SoHtjxBG5l7zspc6anUmUh6xsCcJk4nAcD4znj OsLsoYHpFCUdmEvhfKHLvF9aCZRnXLEfTcei49FeMx65ofo8xc14Ji8doBqc22rjjLh9 noOUwj3w+I+QDKCTikV781cNkgsAaswfVvcKvXRmDP8q9jtCwOXmGxllz/plIK8g5ST6 +tv+Ck4O2VzLnYLNjVyjyS6m2HIk/vNk4uMIEhQNwzeU7ZdHuxmIU9Pl4WEVp+UxeCj/ M9CV7sfyljzLvwN2D5EhAlNXH6dp90rm9isVeu1GsJO0KL8EmtkJJy2KpYc/O1dnAdFU yBKA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=vco0x5XElZtpdNadc096N4nzc3TfmtkF1aye7C23FUo=; fh=U9Vkrj/8YXu+wNKP4ImG87p6jlJYRxuB/zicT9qNons=; b=OGNjQQnBQdoJlrWMz1tjGWRyQp8fIAsSqzpO/QlbNynYx7tS2qgE3jG08HY/20fbgh GUQLvkQatKQu5cV7DOmZvTYcSwatBqjWOfHAXHdQvwTnZxiWPSanVPi2QKm9IYPtlcy1 0uGAgeZHzJT8nnefb6hNgUxRsVnAVA04HEBUtbu7YaYUVRATRiQeEpgTTWEl1sE4cN2A W9GbCsr0bgpEc8k6vg9qCjO/5dcx4jaND6L8jDpxl7qKoEuPS5Itsm6owA+VzDRT1F+a ZSOLlWRuFWYAvlFuhaWe6W1IUDnvhRKwPjxH0fwWy0PNAE+5dlP2pths+dwDIhrNWzQZ ys2g==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1770738952; x=1771343752; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=vco0x5XElZtpdNadc096N4nzc3TfmtkF1aye7C23FUo=; b=bUGqhEYF5ZKazLoWkiKtohvtTyIm8n0ToH4XuO559KsL5a2fq3wFY4zwFumk4fUxne OfaZQFF9sYefO+avXNyQaoY0DbRZMbaSHDv1E2zLIjb5cE7RFHWIptnF/0emyY5DGd+t KORrOLZWdnKTFY4bii5XMvBgj5d6c2Grei7x/moy3h5CoB8eMPB04wvFWGitxHdjeLPa Qt2gXKoC9rj330uLq/5fiNcrlxWdFwHNI1jy814jfTFWzg6el+/jrki7Ae4SZvE8wR7Z RXf7hvkWiFo4joiXDXKdaPLpBOpHArt/06CxDhFeHugK6QkqncDc7vNfaehZtEyuvhLr BKlA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1770738952; x=1771343752; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=vco0x5XElZtpdNadc096N4nzc3TfmtkF1aye7C23FUo=; b=WusuCu5mkbFHT4ZsIcp4+Ks4rMxt6n9siRxdG3l34P0ToumTeGpg87Qxf/DxB8nzf0 LrQStUnQAxyqdYAWKX3j2MlK/INIcNr+G6l6nkaHK9qszUVB7Nw1m/Ub7u16VfgDU7/B /J6DQk3upxyXCEprer5+IrssutmFpcDIZ0IfQFugVAlo0nuPLRNBkmXbZt6/E5MF6bgY D1YVELJYtd8rpuoVmVy8Xqjnw3D9z6qbrhcFZgFyGLad8vV0i3efBHdThK8En0rvjzj+ QzC0qmcV3VjV92jOKwPRlSvpgFLVsNRpLn33TbqldWAo4W7A9/qEiw6nNOZ3B/BhMTUd vnUg== X-Gm-Message-State: AOJu0Yz4p3D5e+VaYtgz+AUOSCWxbGmSjWbJ1ECDgoERNMBBG5OJkGKm tjTYMdipbhS/0O0VjEECNrhLAmW8kEsHCKb/mQBrZWvpNE0nUxN1x1aIzLpXc/R3jDzylSIZOaB MM4w8kKYrWYo5ovTJNc6Ot9mbLOEzJ4gqlw== X-Gm-Gg: AZuq6aJuNLN6m7BnZ8iX1JL0lZxTVdJqiucQLJpFiWjtDTPOnsK74G7W5TcasAgAks7 gIvQvt6eVIMm9mNbCPeWrc7yHnGv11R43terOjGgnTV+Zq/DdBuQWoREexyhxHZ6pmI7iSsHtN9 jpphuJoFtmgAzZO/BLeUh5/4ms2I3Zaw+R7HHorH6/EY+tQkMu+lW70Utz6WS3eevBGktB8Tc4u zPpc027nV/872CXKaRIIPa8wHXADojpIkLQwoYNA0H6hdEyy+C434Zk023Bd8LSaeyF/7q265pQ a66hcYRVx8k3bMBZqXE= X-Received: by 2002:a17:907:1c85:b0:b8d:bfb9:aefc with SMTP id a640c23a62f3a-b8edf179b16mr914405666b.11.1770738951536; Tue, 10 Feb 2026 07:55:51 -0800 (PST) MIME-Version: 1.0 From: Durgamahesh Manne Date: Tue, 10 Feb 2026 21:25:38 +0530 X-Gm-Features: AZwV_QgNnAgCl6PgcYmQoun6vUOOgSytcuz3496cictH0clVfGtXezeWR4mT7R4 Message-ID: Subject: Fillfactor effectiveness on existing table To: pgsql-general Content-Type: multipart/alternative; boundary="0000000000003243dc064a7a4aa0" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003243dc064a7a4aa0 Content-Type: text/plain; charset="UTF-8" Hi I added fillfactor with less than 100 to existing table then ran vacuum full to take effect How to ensure the applied fillfactor is working successfully A ratio of hot updates in catalog table should higher than value of n_dead_tup or n_tup_upd? Or what ? Regards, Durga Mahesh --0000000000003243dc064a7a4aa0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0

I a= dded fillfactor with less than 100 to existing table then ran vacuum full t= o take effect=C2=A0

How = to ensure the applied fillfactor is working successfully=C2=A0

A ratio of hot updates in catalog ta= ble should higher than value of n_dead_tup or n_tup_upd? Or what ?


Rega= rds,
Durga Mahesh

<= div dir=3D"auto">

--0000000000003243dc064a7a4aa0--