public inbox for [email protected]
help / color / mirror / Atom feedRe: Fillfactor effectiveness on existing table
2+ messages / 2 participants
[nested] [flat]
* Re: Fillfactor effectiveness on existing table
@ 2026-02-11 03:02 Ron Johnson <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Ron Johnson @ 2026-02-11 03:02 UTC (permalink / raw)
To: pgsql-general <[email protected]>
On Tue, Feb 10, 2026 at 9:34 PM Durgamahesh Manne <[email protected]>
wrote:
>
>
> On Tue, 10 Feb, 2026, 22:58 Ron Johnson, <[email protected]> wrote:
>
>> On Tue, Feb 10, 2026 at 11:05 AM David G. Johnston <
>> [email protected]> wrote:
>>
>>> On Tuesday, February 10, 2026, Durgamahesh Manne <
>>> [email protected]> wrote:
>>>
>>>> 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 ?
>>>>
>>>>
>>> While free space on the page is necessary for HOT, it is not sufficient.
>>>
>>> If you want to prove fillfactor isn’t buggy I’d suggest contriving a
>>> test case instead inspecting complex real data. A table with a single
>>> bigint and say 50 fillfactor should be easily visible when inspecting the
>>> free space of a page in the heap (not sure of the exact query for this
>>> though). There is a page-inspect contrib extension that provides low-level
>>> details.
>>>
>>
>> What about pgstattuple.free_space and free_percent?
>>
> Hi @Ron <[email protected]>
> approx_free_space | 13227478672 approx_free_percent | 30.89065723142561
>
> Free space can be considered as bloat for non toast table but not for both
> toast and non toast I believe
>
1) Did you vacuum?
2) What's the fillfactor?
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Fillfactor effectiveness on existing table
@ 2026-02-11 03:26 Durgamahesh Manne <[email protected]>
parent: Ron Johnson <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Durgamahesh Manne @ 2026-02-11 03:26 UTC (permalink / raw)
To: Ron Johnson <[email protected]>; +Cc: pgsql-general <[email protected]>
On Wed, 11 Feb, 2026, 08:32 Ron Johnson, <[email protected]> wrote:
> On Tue, Feb 10, 2026 at 9:34 PM Durgamahesh Manne <
> [email protected]> wrote:
>
>>
>>
>> On Tue, 10 Feb, 2026, 22:58 Ron Johnson, <[email protected]> wrote:
>>
>>> On Tue, Feb 10, 2026 at 11:05 AM David G. Johnston <
>>> [email protected]> wrote:
>>>
>>>> On Tuesday, February 10, 2026, Durgamahesh Manne <
>>>> [email protected]> wrote:
>>>>
>>>>> 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 ?
>>>>>
>>>>>
>>>> While free space on the page is necessary for HOT, it is not sufficient.
>>>>
>>>> If you want to prove fillfactor isn’t buggy I’d suggest contriving a
>>>> test case instead inspecting complex real data. A table with a single
>>>> bigint and say 50 fillfactor should be easily visible when inspecting the
>>>> free space of a page in the heap (not sure of the exact query for this
>>>> though). There is a page-inspect contrib extension that provides low-level
>>>> details.
>>>>
>>>
>>> What about pgstattuple.free_space and free_percent?
>>>
>> Hi @Ron <[email protected]>
>> approx_free_space | 13227478672 approx_free_percent | 30.89065723142561
>>
>> Free space can be considered as bloat for non toast table but not for
>> both toast and non toast I believe
>>
>
> 1) Did you vacuum?
> 2) What's the fillfactor?
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
>
@Ron <[email protected]>
Hi
1) vacuum runs daily once and autovacuum triggers for every 1 hour
2) 80
Regards
Durga Mahesh
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-02-11 03:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-02-11 03:02 Re: Fillfactor effectiveness on existing table Ron Johnson <[email protected]>
2026-02-11 03:26 ` Durgamahesh Manne <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox