Little understanding for tuning ...

From: Hervé Piedvache <herve(at)elma(dot)fr>
To: pgsql-performance(at)postgresql(dot)org
Subject: Little understanding for tuning ...
Date: 2004-07-27 07:35:33
Message-ID: 200407270935.33431.herve@elma.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2004-07-27 13:07:02 best way to fetch next/prev record based on index
Previous Message Greg Stark 2004-07-27 04:32:37 Re: arrays and indexes