Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 772CE2E0037 for ; Thu, 17 Apr 2008 16:49:15 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 57173-01 for ; Thu, 17 Apr 2008 16:49:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from shrek.krogh.cc (2605ds1-ynoe.1.fullrate.dk [90.184.12.24]) by developer.postgresql.org (Postfix) with ESMTP id 755752E0032 for ; Thu, 17 Apr 2008 16:49:04 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by shrek.krogh.cc (Postfix) with ESMTP id B2A993BF416 for ; Thu, 17 Apr 2008 21:48:56 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at shrek.krogh.cc Received: from shrek.krogh.cc ([127.0.0.1]) by localhost (shrek.krogh.cc [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id idpQuZJT20-8 for ; Thu, 17 Apr 2008 21:48:45 +0200 (CEST) Received: from [192.168.1.5] (unknown [90.184.13.46]) by shrek.krogh.cc (Postfix) with ESMTP id BBC253BF3A9 for ; Thu, 17 Apr 2008 21:48:45 +0200 (CEST) Message-ID: <4807A9A1.9040806@krogh.cc> Date: Thu, 17 Apr 2008 21:48:49 +0200 From: Jesper Krogh User-Agent: Thunderbird 2.0.0.12 (X11/20080227) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: autovacuum? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/179 X-Sequence-Number: 28943 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