Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 48E18A0FB34
	for <pgsql-admin@postgresql.org>; Wed,  4 Jul 2012 16:31:15 -0300 (ADT)
Received: from nrccenhts2.nrc.ca ([132.246.15.89] helo=nrccenhts1.nrc.ca)
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <Isabella.Ghiurea@nrc-cnrc.gc.ca>) id 1SmVI8-00038u-Ln
	for pgsql-admin@postgresql.org; Wed, 04 Jul 2012 19:31:15 +0000
Received: from NRCWSTHCM1.NRC.CA (132.246.216.66) by nrccenhts2.nrc.ca
	(132.246.15.89) with Microsoft SMTP Server (TLS) id 8.3.245.1;
	Wed, 4 Jul 2012 15:30:57 -0400
Received: from [132.246.194.15] (132.246.216.202) by WSTMAIL.NRC.CA
	(132.246.216.66) with Microsoft SMTP Server (TLS) id 8.3.245.1;
	Wed, 4 Jul 2012 12:30:56 -0700
Message-ID: <4FF499F0.9030601@nrc-cnrc.gc.ca>
Date: Wed, 4 Jul 2012 12:30:56 -0700
From: Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>
Reply-To: isabella.ghiurea@nrc-cnrc.gc.ca
Organization: CADC -NRC
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:12.0) Gecko/20120430 Thunderbird/12.0.1
MIME-Version: 1.0
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: auto vacuum   errors
Content-Type: multipart/alternative;
	boundary="------------090705030301060108070703"
X-Pg-Spam-Score: -1.5 (-)
X-Archive-Number: 201207/17
X-Sequence-Number: 39734

--------------090705030301060108070703
Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
Content-Transfer-Encoding: 7bit

HI Gurus
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  ?
The temp tables are growing too fast and  they don't get 
empty/clean-up...any tips ? I 'm running PGSQL 8.3.6 on RHES.
Isabella

-- 
-----------------------------------------------------------
Isabella A. Ghiurea

Isabella.Ghiurea@nrc-cnrc.gc.ca
Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html
National Research Council of Canada, Herzberg Institute of Astrophysics
5071 West Saanich Road, Victoria BC V9E 2E7, Canada
Phone: 250 363-3446 fax: 250 363-0045


--------------090705030301060108070703
Content-Type: text/html; charset="ISO-8859-1"
Content-Transfer-Encoding: 7bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <font size="-1">HI Gurus<br>
      I'm seeing a issue with some temp tables in contrib_regression db
      , the auto vacuum job will not run for this tables&nbsp; due some
      files/QID's&nbsp; missing&nbsp; how can I fix this&nbsp; ?<br>
      The temp tables are growing too fast and&nbsp; they don't get
      empty/clean-up...any tips ? I 'm running PGSQL 8.3.6 on RHES.<br>
      Isabella<br>
      <br>
    </font>
    <pre class="moz-signature" cols="72">-- 
-----------------------------------------------------------
Isabella A. Ghiurea 

<a class="moz-txt-link-abbreviated" href="mailto:Isabella.Ghiurea@nrc-cnrc.gc.ca">Isabella.Ghiurea@nrc-cnrc.gc.ca</a>
Canadian Astronomy Data Centre |<a class="moz-txt-link-freetext" href="http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html">http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html</a> 
National Research Council of Canada, Herzberg Institute of Astrophysics 
5071 West Saanich Road, Victoria BC V9E 2E7, Canada
Phone: 250 363-3446 fax: 250 363-0045
</pre>
  </body>
</html>

--------------090705030301060108070703--