From: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com> |
---|---|
To: | General PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
Subject: | assistance needed for autovacuum on the windows version of 8.2.3 |
Date: | 2007-04-03 21:17:01 |
Message-ID: | 347821.58219.qm@web31802.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Can anyone see why autovacuum or autoanalyze are not working?
proj02u20411=# select version();
version
------------------------------------
PostgreSQL 8.2.3 on i686-pc-mingw32,
compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)
(1 row)
proj02u20411=# explain analyze select * from dev.tag;
QUERY PLAN
----------------------------------------------------------
Seq Scan on tag
(cost=0.00..810.35 rows=18835 width=166)
(actual time=510.270..584.418 rows=2696 loops=1)
Total runtime: 588.207 ms
(2 rows)
proj02u20411=# select *
from pg_stat_all_tables
where schemaname = 'dev'
and relname = 'tag';
-[ RECORD 1 ]----+--------------------------
relid | 16800
schemaname | dev
relname | tag
seq_scan | 255
seq_tup_read | 416689
idx_scan | 4123
idx_tup_fetch | 82080
n_tup_ins | 2585
n_tup_upd | 10
n_tup_del | 0
last_vacuum |
last_autovacuum |
last_analyze |
last_autoanalyze | 2007-01-17 17:57:54.33-08
#---------------------------------------------------------------------------
# RUNTIME STATISTICS
#---------------------------------------------------------------------------
# - Query/Index Statistics Collector -
stats_start_collector = on # needed for block or row stats
# (change requires restart)
stats_row_level = on
#---------------------------------------------------------------------------
# AUTOVACUUM PARAMETERS
#---------------------------------------------------------------------------
autovacuum = on # enable autovacuum subprocess?
# 'on' requires stats_start_collector
# and stats_row_level to also be on
autovacuum_naptime = 1min # time between autovacuum runs
autovacuum_vacuum_threshold = 100 # min # of tuple updates before
# vacuum
autovacuum_analyze_threshold = 25 # min # of tuple updates before
# analyze
autovacuum_vacuum_scale_factor = 0.002 # fraction of rel size before
# vacuum
autovacuum_analyze_scale_factor = 0.001 # fraction of rel size before
# analyze
autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum
# (change requires restart)
autovacuum_vacuum_cost_delay = -1 # default vacuum cost delay for
# autovacuum, -1 means use
# vacuum_cost_delay
autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for
# autovacuum, -1 means use
# vacuum_cost_limit
From | Date | Subject | |
---|---|---|---|
Next Message | Florian G. Pflug | 2007-04-03 21:17:55 | Nice, web-based SNMP-Frontend for pgsnmpd? |
Previous Message | Marcus Engene | 2007-04-03 20:12:44 | speeding up a query |