Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 92761E7DA88 for ; Thu, 5 Jul 2012 01:18:18 -0300 (ADT) Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SmdWD-00049f-Ko for pgsql-admin@postgresql.org; Thu, 05 Jul 2012 04:18:18 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id q654I4KP009817; Thu, 5 Jul 2012 00:18:04 -0400 (EDT) From: Tom Lane To: isabella.ghiurea@nrc-cnrc.gc.ca cc: "pgsql-admin@postgresql.org" Subject: Re: auto vacuum errors In-reply-to: <4FF499F0.9030601@nrc-cnrc.gc.ca> References: <4FF499F0.9030601@nrc-cnrc.gc.ca> Comments: In-reply-to Isabella Ghiurea message dated "Wed, 04 Jul 2012 12:30:56 -0700" Date: Thu, 05 Jul 2012 00:18:03 -0400 Message-ID: <9816.1341461883@sss.pgh.pa.us> X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201207/18 X-Sequence-Number: 39735 Isabella Ghiurea writes: > I'm seeing a issue with some temp tables in contrib_regression db , the > auto vacuum job will not run for this tables due some files/QID's > missing how can I fix this ? Um ... in general, autovacuum just silently ignores temp tables, because it doesn't have any way to access their contents. (One of the reasons that temp tables are fast is that the backend owning a temp table keeps its data in local buffers, not in shared buffers that another process could access.) I wouldn't expect any "missing file" complaints though. What exactly were you seeing? regards, tom lane