Re: max_fsm_pages

If you increase max_fsm_pages to a large enough number then the next
vacuum analyze will make all the pages with free space available to be
reused. A normal VACUUM does not actually reclaim space (unless it's at
the end of the table I think), it only marks the space as reuseable.
VACUUM FULL will reclaim space immediately.

Matthew

wespvp(at)syntegra(dot)com wrote:

> If max_fsm_pages is too small and I have space not reclaimed by vacuum, if I
> increase max_fsm_pages and restart postmaster, will the next VACUUM ANALYZE
> relcaim all overlooked pages or must I do a VACUUM FULL?
>
> Wes
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>