From: Jesper Krogh <jesper@krogh.cc>
To: pgsql-admin@postgresql.org
Subject: autovacuum?
Date: Thu, 17 Apr 2008 21:48:49 +0200
Message-ID: <4807A9A1.9040806@krogh.cc> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jesper@krogh.cc
Subject: Re: autovacuum?
In-Reply-To: <4807A9A1.9040806@krogh.cc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox