From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jouneau Luc <Luc.Jouneau@jouy.inra.fr>
Cc: pgsql-admin@postgresql.org
Subject: Re: max_fsm_pages
Date: Thu, 04 Sep 2003 19:24:04 -0400
Message-ID: <12061.1062717844@sss.pgh.pa.us> (raw)
In-Reply-To: <007c01c372f0$95b80b10$4703668a@pc502jlo>
References: <007c01c372f0$95b80b10$4703668a@pc502jlo>
"Jouneau Luc" <Luc.Jouneau@jouy.inra.fr> writes:
> INFO: Pages 11944: Changed 11944, Empty 0; Tup 32: Vac 1931936, Keep 0, Un=
> Used 0.
> Total CPU 1.57s/1.90u sec elapsed 42.01 sec.
> It seems that FSM traced all of my deletes since it mentions removes in 864=
> 1+3303=3D11944 pages (>10000 which was set for max_fsm_page).
The numbers output by VACUUM don't tell you anything about how many of
those pages will actually be remembered in the FSM.
In practice, max_fsm_relations=100 is too small; we've bumped the
default to 1000 for 7.4.
> My first aim was to know if max_fsm_pages was set for each table or for a w=
> hole database.
Whole database. That default setting is very small, too (enough for
a database of maybe a couple hundred meg, at most).
regards, tom lane
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-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, Luc.Jouneau@jouy.inra.fr
Subject: Re: max_fsm_pages
In-Reply-To: <12061.1062717844@sss.pgh.pa.us>
* 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