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