assistance needed for autovacuum on the windows version of 8.2.3

Поиск
Список
Период
Сортировка
От Richard Broersma Jr
Тема assistance needed for autovacuum on the windows version of 8.2.3
Дата
Msg-id 347821.58219.qm@web31802.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: assistance needed for autovacuum on the windows version of 8.2.3
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Florian G. Pflug"
Дата:
Сообщение: Nice, web-based SNMP-Frontend for pgsnmpd?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: assistance needed for autovacuum on the windows version of 8.2.3