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

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin