Re: [PERFORM] max fsm pages question

2008-07-09 Thread Vivek Khera
On Jul 8, 2008, at 3:24 PM, Bill Moran wrote: If you don't handle this, that table will continue to grow in size on the disk, taking up space unnecessarily and probably negatively impacting performance. s/probably/definitely/ Also, if it was #3 on Bill's list, one thing to do is look for ind

Re: [PERFORM] max fsm pages question

2008-07-08 Thread Bill Moran
In response to "Radhika S" <[EMAIL PROTECTED]>: > > 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 t

[PERFORM] max fsm pages question

2008-07-08 Thread Radhika S
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_