From: Radhika S <radhika.sambamurti@gmail.com>
To: pgsql-performance@postgresql.org
Subject: max fsm pages question
Date: Tue, 8 Jul 2008 15:13:39 -0400
Message-ID: <fe27bfd40807081213q4a8bba99yeda5dd748ea235ca@mail.gmail.com> (raw)
Hi,
when i issued the vaccuum cmd, I recieved this message:
echo "VACUUM --full -d ARSys" | psql -d dbname
WARNING: relation "public.tradetbl" contains more than
"max_fsm_pages" pages with useful free space
HINT: Consider compacting this relation or increasing the
configuration parameter "max_fsm_pages".
NOTICE: number of page slots needed (309616) exceeds max_fsm_pages (153600)
HINT: Consider increasing the configuration parameter "max_fsm_pages"
to a value over 309616.
VACUUM
What does the warning indicate? How will it adversely affect the system.
Thanks.
-rs
--
It is all a matter of perspective. You choose your view by choosing
where to stand. --Larry Wall
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: radhika.sambamurti@gmail.com
Subject: Re: max fsm pages question
In-Reply-To: <fe27bfd40807081213q4a8bba99yeda5dd748ea235ca@mail.gmail.com>
* 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