From: Hervé Piedvache <herve@elma.fr>
To: pgsql-performance@postgresql.org
Subject: Little understanding for tuning ...
Date: Tue, 27 Jul 2004 09:35:33 +0200
Message-ID: <200407270935.33431.herve@elma.fr> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: herve@elma.fr
Subject: Re: Little understanding for tuning ...
In-Reply-To: <200407270935.33431.herve@elma.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox