Re: vacuum & free space map - Mailing list pgsql-general

From Tom Lane
Subject Re: vacuum & free space map
Date
Msg-id 19687.1565099437@sss.pgh.pa.us
Whole thread Raw
In response to vacuum & free space map  (Luca Ferrari <fluca1978@gmail.com>)
Responses Re: vacuum & free space map
List pgsql-general
Luca Ferrari <fluca1978@gmail.com> writes:
> I'm not understanding why a vacuum full clears a FSM information while
> a normal vacuum does not. On a table with fillfactor = 50 I've got:

VAC FULL builds a new physical table, which has no FSM to start with.
Possibly, when fillfactor < 100, that's something that should be
created; the decision not to bother is probably older than the
fillfactor knob.

            regards, tom lane



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Preventing in-session 'set role' commands
Next
From: Adrian Klaver
Date:
Subject: Re: Does pgadmin4 work with postgresql 8.4?