Wayne Conrad wrote: > We started doing a routine VACUUM FULL ANALYZE on the advice of a > friend after the database started getting slow over time. We did not > realize that the FULL should never be done. We will change that to a > VACUUM ANALYZE, without the full, and see how it goes. > > We discovered that an occasionally REINDEX was also required to keep > things fast. We did not realize it was a direct result of the VACUUM > FULL that the REINDEX was required.
You probably need to increase the size of the free space map too. See the fsm_max_pages parameter in postgresql.conf. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
