max fsm pages question

From: "Radhika S" <radhika(dot)sambamurti(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: max fsm pages question
Date: 2008-07-08 19:13:39
Message-ID: fe27bfd40807081213q4a8bba99yeda5dd748ea235ca@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeremy Harris 2008-07-08 19:24:41 Re: Fusion-io ioDrive
Previous Message Jeff 2008-07-08 19:00:06 Re: syslog performance when logging big statements