<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <link rel="STYLESHEET" type="text/css" href="../pgadmin3.css"> <title>Guru Hints</title> </head> <body> <h3>Running autovacuum recommended</h3> <p> Introduced in PostgreSQL 8.1, the autovacuum process which was previously implemented as an external service process is now integrated into the backend. It will run VACUUM automatically if a configurable amount of data has changed. </p> <p> Running VACUUM is mandatory on a PostgreSQL server to keep data consistent and the server performant. As a start, it is recommended to enable the autovacuum daemon by setting 'autovacuum', 'stats_start_collector' and 'stats_row_level' in postgresql.conf to 'on'. <p> In PostgreSQL 8.3 and newer, autovacuum is enabled by default unless you turn off 'track_activities' or 'track_counts'. </p> <p> With a usually neglible performance penalty from the data change tracking, you will gain automatic VACUUM runs. </p> <p> To adjust autovacuum performance for individual needs, you might need to tune its settings using global parameters in postgresql.conf, or individually on each table; see the documentation. </p> </body> </html>
distrib
>
Fedora
>
13
>
i386
>
media
>
updates
>
by-pkgid
>
cb664fc35171072d04824accda2566aa
>
files
>
162
