Senhores, toda vez que conecto pelo pgAdmin3 ele me dá essa mensagem abaixo

Devo ativar o Autovacuum como ele recomenda ou ignoro?


Inicio

Running autovacuum recommended

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. 
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'. 
In PostgreSQL 8.3 and newer, autovacuum is enabled by default unless you turn 
off 'track_activities' or 'track_counts'. 
With a usually neglible performance penalty from the data change tracking, you 
will gain automatic VACUUM runs. 
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. 

Fim



Marcelo Silva
----------------------------------
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a