Re: Autovaccum

Hi, Ezequias,

"Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com> wrote:

> What is the interval of time the vacuum will run on my database ?

That depends on your settings and load.

Autovacuum looks at every table, and checks the number of
modifications, as well as the total number of transactions since the
last vacuum, and decides whether to VACUUM and/or ANALYZE.

The thresholds for those settings can be configured per table, with the
defaults in the postgresql.conf.


Regards,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org