Prabhjot Sheena wrote: > While the vacuumdb --analyze command is running i m getting these messages > for these tables which might require full vacuum. > > WARNING: relation "public.result" contains more than "max_fsm_pages" pages > with useful free space > HINT: Consider using VACUUM FULL on this relation or increasing the > configuration parameter "max_fsm_pages". Ouch. I had read you were on 9.3 in your first email, but this message gives me a trip back in time a decade ago -- you're on 8.3! Clearly you have had vacuuming issues for a long time. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
