Little understanding for tuning ... - Mailing list pgsql-performance

From Hervé Piedvache
Subject Little understanding for tuning ...
Date
Msg-id 200407270935.33431.herve@elma.fr
Whole thread Raw
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Greg Stark
Date:
Subject: Re: arrays and indexes
Next
From: "Merlin Moncure"
Date:
Subject: best way to fetch next/prev record based on index