Thread: Little understanding for tuning ...

Little understanding for tuning ...

From
Hervé Piedvache
Date:
Dear all,

This is my two last line of a vacuum full verbose analyse;.

INFO:  free space map: 27 relations, 4336 pages stored; 3232 total pages
needed
DETAIL:  Allocated FSM size: 2000 relations + 50000000 pages = 293088 kB

What are the good parameters to set with those informations :

max_fsm_pages = 30000  
max_fsm_relations = 100

Any other parameters could be defined with this informations ?

Thanks per advance,
--
Hervé Piedvache

Elma Ingénierie Informatique
6 rue du Faubourg Saint-Honoré
F-75008 - Paris - France
Pho. 33-144949901
Fax. 33-144949902