Ezequias Rodrigues da Rocha wrote: > Hi list, > > I would like to know if it is necessary to set my database to > autovaccum if the intent of my DB Manager is do not make any deletion > in any time. > > If there is no deletions why autovaccum ok ?
You need to vacuum from time to time anyway, even if you don't delete anything. The easiest way to do it is let autovacuum do it for you. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
