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.
