negative values for vacuum threshold check !!!

From: Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: negative values for vacuum threshold check !!!
Date: 2008-08-20 15:09:18
Message-ID: 1219244958.14579.73.camel@jmf-ubuntu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all

While debugging my autovacuum I increased the level of logging to
"debug3" and got this:

# cat /var/pgsql/data/logfile | grep vac | egrep "mydb|mytable"

LOG: autovacuum: processing database "mydb"
DEBUG: mytbl: vac: 10409 (threshold 200000), anl: -183366 (threshold
50000)
LOG: autovacuum: processing database "mydb"
DEBUG: mytbl: vac: 10966 (threshold 200000), anl: -182489 (threshold
50000)
LOG: autovacuum: processing database "mydb"
DEBUG: mytbl: vac: 11545 (threshold 200000), anl: -181592 (threshold
50000)

Should I be worried with the negative values in 'anl' ?

thx
joao

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-08-20 15:35:44 Re: schema name in SQL statement.
Previous Message Alexi Gen 2008-08-20 14:56:31 Time of 'pg_ctl reload'.