Re: BUG #4730: Vacuum full verbose analyze "deadlock"

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.