From: | Miguel <mmiranda(at)123(dot)com(dot)sv> |
---|---|
To: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | frecuencia autovacuum |
Date: | 2006-03-27 21:44:31 |
Message-ID: | 44285CBF.4090709@123.com.sv |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Hola, estoy tratando de hacer funcionar el nuevo demonio autovacuum,
pero por alguna razon se esta corriendo con demasiada frecuenciam, los
parametros en postgresql.conf son los siguientes (practicamente los
default):
#---------------------------------------------------------------------------
# AUTOVACUUM PARAMETERS
#---------------------------------------------------------------------------
autovacuum = on # enable autovacuum subprocess?
#autovacuum_naptime = 60 # time between autovacuum runs,
in secs
#autovacuum_vacuum_threshold = 1000 # min # of tuple updates before
# vacuum
#autovacuum_analyze_threshold = 500 # min # of tuple updates before
# analyze
#autovacuum_vacuum_scale_factor = 0.4 # fraction of rel size before
# vacuum
#autovacuum_analyze_scale_factor = 0.2 # fraction of rel size before
# analyze
#autovacuum_vacuum_cost_delay = -1 # default vacuum cost delay for
# autovac, -1 means use
# vacuum_cost_delay
#autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for
# autovac, -1 means use
# vacuum_cost_limit
y en el log me aparece:
2006-03-27 15:17:00 CST LOG: autovacuum: processing database "radius"
2006-03-27 15:18:00 CST LOG: autovacuum: processing database "postgres"
2006-03-27 15:19:00 CST LOG: autovacuum: processing database "radius"
2006-03-27 15:20:00 CST LOG: autovacuum: processing database "postgres"
2006-03-27 15:21:00 CST LOG: autovacuum: processing database "radius"
2006-03-27 15:22:00 CST LOG: autovacuum: processing database "postgres"
2006-03-27 15:23:00 CST LOG: autovacuum: processing database "radius"
2006-03-27 15:24:00 CST LOG: autovacuum: processing database "postgres"
2006-03-27 15:25:00 CST LOG: autovacuum: processing database "radius"
2006-03-27 15:26:00 CST LOG: autovacuum: processing database "postgres"
2006-03-27 15:27:00 CST LOG: autovacuum: processing database "radius"
2006-03-27 15:28:00 CST LOG: autovacuum: processing database "postgres"
2006-03-27 15:29:00 CST LOG: autovacuum: processing database "radius"
2006-03-27 15:30:00 CST LOG: autovacuum: processing database "postgres"
2006-03-27 15:31:00 CST LOG: autovacuum: processing database "radius"
2006-03-27 15:32:00 CST LOG: autovacuum: processing database "postgres"
2006-03-27 15:33:00 CST LOG: autovacuum: processing database "radius"
2006-03-27 15:34:00 CST LOG: autovacuum: processing database "postgres"
2006-03-27 15:35:00 CST LOG: autovacuum: processing database "radius"
2006-03-27 15:36:00 CST LOG: autovacuum: processing database "postgres"
2006-03-27 15:37:00 CST LOG: autovacuum: processing database "radius"
2006-03-27 15:38:00 CST LOG: autovacuum: processing database "postgres"
2006-03-27 15:39:00 CST LOG: autovacuum: processing database "radius"
este es un servidor de prueba, no tiene ninguna actividad, esta recien
instalado,
cual prodria ser el problema?
atte
From | Date | Subject | |
---|---|---|---|
Next Message | proves_es | 2006-03-27 21:45:02 | Re: PostgreSQL desde Visual Basic |
Previous Message | Martin Marques | 2006-03-27 21:15:14 | Re: problemas con permisos |