>> > max_fsm_pages = 2800000
>> > max_fsm_relations = 160000
>
>> What does the last couple of lines from a 'vacuum analyze verbose'
>> say? I have max_fsm_pages = 4000000 and max_fsm_relations = 1500.
>
>> You can also try to lower random_page_cost to a lower value like 1.2
>> but I doubt this will help in your case.
>
> last couple lines from 'vacuumdb -a -v -z':
>
> INFO: free space map contains 114754 pages in 42148 relations
> DETAIL: A total of 734736 page slots are in use (including overhead).
----------------vvvvv-----------
> 734736 page slots are required to track all free space.
----------------^^^^^-----------
> Current limits are: 2800000 page slots, 160000 relations, using 26810 kB.
You can lower your max_fsm_pages setting to a number above 'xyz page
slots required ...' to 1000000 and fsm-relations to like 50000.
--
regards
Claus
When lenity and cruelty play for a kingdom,
the gentler gamester is the soonest winner.
Shakespeare
