Fillfactor effectiveness on existing table

Durgamahesh Manne <maheshpostgres9@gmail.com>

From: Durgamahesh Manne <maheshpostgres9@gmail.com>
To: pgsql-general <pgsql-general@lists.postgresql.org>
Date: 2026-02-10T15:55:38Z
Lists: pgsql-general
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