Denis Gasparin wrote:
> Another question/idea: why don't put messages about what tables got
> vacuumed by the autovacuum daemon as normal log messages (instead of
> debug2)?
We did that for 8.3, actually.
> I think it could be useful because in this way you can also know what
> tables are used m
Alvaro Herrera ha scritto:
>> However i have no idea of what tables the autovacuum daemon is
>> processing because there aren't autovacuum info columns on
>> pg_stat_all_tables (as there are for 8.2.x).
>>
>
> For that, you need to change log_min_messages to debug2.
>
> Keep track of the PID o
Denis Gasparin wrote:
> How is it possibile to check if autovacuum is running in 8.1.x?
>
> "Show Autovacuum" gives me "on" and also i see evidence in logs
> where,autovacuum writes "LOG: autovacuum: processing database ".
Then it is running.
> However i have no idea of what tables the auto
How is it possibile to check if autovacuum is running in 8.1.x?
"Show Autovacuum" gives me "on" and also i see evidence in logs
where,autovacuum writes "LOG: autovacuum: processing database ".
However i have no idea of what tables the autovacuum daemon is
processing because there aren't auto
How is it possibile to check if autovacuum is running in 8.1.x?
"Show Autovacuum" gives me on and also i see evidence in logs where
autovacuum writes "LOG: autovacuum: processing database ".
However i have no idea of what tables the autovacuum daemon is
processing because there aren't autova
