Wayne Conrad <wcon...@yagni.com> wrote: > the database started getting slow over time. As Alvaro pointed out, this can happen if your fsm configuration doesn't allow enough space for a normal VACUUM to keep track of all the free space. Since you're running VACUUM with the VERBOSE option, be sure to capture the output and review the last few lines; this will tell you what setting you have and the minimum which would cover current needs. Also, be sure you haven't disabled autovacuum along the way. There are some usage patterns which require special forms of maintenance, but VACUUM FULL usually isn't the best option for routine maintenance. If you notice performance degrading again, please post details on the performance list. I hope this helps. -Kevin
-- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
