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

autovacuum?

From: Jesper Krogh <jesper(at)krogh(dot)cc>
To: pgsql-admin(at)postgresql(dot)org
Subject: autovacuum?
Date: 2008-04-17 19:48:49
Message-ID: 4807A9A1.9040806@krogh.cc (view raw or flat)
Thread:
Lists: pgsql-admin
Hi.

I have a mostly insert/select database, so vacumming is generally not 
much needed.. but among the tables I have one which is used as a 
message-queue so a lot of insert/updates/deletes on small simple records 
on that one.

How do I check that autovacumm is running at all? (I think i have 
enabled it in /etc/postgresql/8.2/*/postgresql.conf ).

select relname,last_autovacuum,last_autoanalyze from pg_stat_user_tables 
where relname = 'job';
  relname |        last_autovacuum        |       last_autoanalyze
---------+-------------------------------+-------------------------------
  job     | 2008-04-16 07:19:24.832413+02 | 2008-04-17 01:40:05.242914+02


So it seems to be running. But shouldn't it hit the table a lot more?
How do I check that it is somehow near optimal?


-- 
Jesper

Responses

pgsql-admin by date

Next:From: David JorjolianiDate: 2008-04-17 20:21:23
Subject: Database update problem from crontab on ubuntu server
Previous:From: Peter KoczanDate: 2008-04-17 16:40:22
Subject: PG 8.3 and kerberos failures

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