Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group