Fillfactor effectiveness on existing table

From: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Fillfactor effectiveness on existing table
Date: 2026-02-10 15:55:38
Message-ID: CAJCZko+BFu4c4moqA5kMoJx3776xdYfEsxJQVNu_YYgrBmsCyQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2026-02-10 16:05:06 Re: Fillfactor effectiveness on existing table
Previous Message Christophe Pettus 2026-02-10 01:42:33 Re: JetBrains: Invoice JBAINV26114490