Skip site navigation (1) Skip section navigation (2)

Autovacuum working / not working ?

From: "Machiel Richards" <machielr(at)rdc(dot)co(dot)za>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Autovacuum working / not working ?
Date: 2010-05-05 05:28:04
Message-ID: 002501caec13$bedf4f00$3c9ded00$@co.za (view raw or flat)
Thread:
Lists: pgsql-novice
Hi All

 

   I hope that someone can perhaps assist me with some insight into the
autovacuum as well.

 

    I have a couple of Postgresql databases at a client site.

 

   The autovacuum is enabled, however when I run the sql query below it does
not return any results:

 

Query:

select relname, last_vacuum, last_analyze,last_autovacuum,last_autoanalyze

from pg_stat_all_tables

where schemaname = 'public';

 

results:

 

postgres-# where schemaname = 'public';

 relname | last_vacuum | last_analyze | last_autovacuum | last_autoanalyze

---------+-------------+--------------+-----------------+------------------

(0 rows)

 

 

 

                They are running  a combination of postgresql 8.1 and 8.3
over a couple of servers.

 

  The current settings for the autovacuum are as follows:

 

   

autovacuum                      | on                                       |
Starts the autovacuum subprocess.

 autovacuum_analyze_scale_factor | 0.1
| Number of tuple inserts, updates or deletes prior to analyze as a fraction
of reltuples.

 autovacuum_analyze_threshold    | 50
| Minimum number of tuple inserts, updates or deletes prior to analyze.

 autovacuum_freeze_max_age       | 200000000
| Age at which to autovacuum a table to prevent transaction ID wraparound.

 autovacuum_max_workers          | 3
| Sets the maximum number of simultaneously running autovacuum worker
processes.

 autovacuum_naptime              | 1min
| Time to sleep between autovacuum runs.

 autovacuum_vacuum_cost_delay    | 20ms
| Vacuum cost delay in milliseconds, for autovacuum.

 autovacuum_vacuum_cost_limit    | -1
| Vacuum cost amount available before napping, for autovacuum.

 autovacuum_vacuum_scale_factor  | 0.2
| Number of tuple updates or deletes prior to vacuum as a fraction of
reltuples.

 autovacuum_vacuum_threshold     | 50                       

 

 

Your assistance will be appreciated.

 

 

Machiel Richards

MySQL DBA

Relational Database Consulting 

 

RDC_Logo

 

Responses

pgsql-novice by date

Next:From: Jaime CasanovaDate: 2010-05-05 05:37:42
Subject: Re: Autovaccum and Full vacuum
Previous:From: Shoaib MirDate: 2010-05-05 05:01:04
Subject: Re: Autovaccum and Full vacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group