pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



Message-ID: <200407270935.33431.herve@elma.fr>
Permalink:  ../200407270935.33431.herve@elma.fr/
Also on:    postgresql.org/message-id/200407270935.33431.herve@elma.fr

 · 

reply

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