Re: Setting max_fsm_pages

As we're talking about fsm, I've got a question I've been asking myself for
some time :
If a cluster is restarted, is the fsm forgotten ? (so does it mean one should
run a vacuum as soon as the database is restarted ?)

Le Dimanche 06 Novembre 2005 03:44, Carlos Oliva a écrit :
> Should I set the max_fsm_pages to the value reported (vacuum verbose) as
> pages stored or the value reported as total pages needed? I ran full +
> analyze vacuums in my database (vacuumdb -f -z -v <database name>) a couple
> of times and I got the following reports:
>
> INFO: free space map: 454 relations, 22274 pages stored; 147328 total
> pages needed
>
> DETAIL: Allocated FSM size: 1000 relations + 20000 pages = 178 kB shared
> memory
>
>
>
> And
>
>
>
> INFO: free space map: 454 relations, 22242 pages stored; 147328 total
> pages needed
>
> DETAIL: Allocated FSM size: 1000 relations + 20000 pages = 178 kB shared
> memory
>
>
>
> I am not sure if I need to raise the max_fsm_pages to something larger than
> 22242 (e.g. 40000) or larger than 147,328.