| 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: | Whole Thread | Raw Message | 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
| 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 |