Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 8891BB5DC63 for ; Fri, 15 Jul 2011 14:06:34 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 89902-10 for ; Fri, 15 Jul 2011 17:06:28 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mmp1.nems.noaa.gov (mmp1.nems.noaa.gov [140.90.121.156]) by mail.postgresql.org (Postfix) with ESMTP id CC62BB5DBF5 for ; Fri, 15 Jul 2011 14:06:27 -0300 (ADT) Received: from [198.206.39.117] by mmp1.nems.noaa.gov (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0LOD00P7VWUR5DA0@mmp1.nems.noaa.gov> for pgsql-admin@postgresql.org; Fri, 15 Jul 2011 13:06:27 -0400 (EDT) Date: Fri, 15 Jul 2011 13:06:15 -0400 From: David Ondrejik Subject: Re: vacuumdb question/problem In-reply-to: To: Simon Riggs , pgsql-admin Message-id: <4E207387.4060508@noaa.gov> MIME-version: 1.0 Content-type: multipart/mixed; boundary="Boundary_(ID_NdXjnldqcjZe48o1h/9wfg)" References: <4E206658.4040600@noaa.gov> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.8) Gecko/20100802 Thunderbird/3.1.2 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=0.001 X-Spam-Level: X-Archive-Number: 201107/114 X-Sequence-Number: 37893 This is a multi-part message in MIME format. --Boundary_(ID_NdXjnldqcjZe48o1h/9wfg) Content-type: text/plain; charset=UTF-8; format=flowed Content-transfer-encoding: 7BIT Simon - thanks for the response. I checked all the processes and nothing appears to be holding it up. Any other advice? Simon Riggs said the following on 7/15/2011 12:21 PM: > On Fri, Jul 15, 2011 at 5:10 PM, David Ondrejik wrote: > >> Since then, the process has continued to run (for about 20 hrs) without any >> additional information being returned. > Probably locked behind another long running task that is holding a buffer pin. > --Boundary_(ID_NdXjnldqcjZe48o1h/9wfg) Content-type: text/x-vcard; charset=utf-8; name=david_ondrejik.vcf Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=david_ondrejik.vcf begin:vcard fn:David Ondrejik n:Ondrejik;David org:weather.gov/marfc;NOAA's National Weather Service adr;dom:Suite #330;;328 Innovation Blvd;State College;PA;16803 email;internet:david.ondrejik@noaa.gov title:Senior Hydrologist. Mid-Atlantic River Forecast Center tel;work:814-231-2401 version:2.1 end:vcard --Boundary_(ID_NdXjnldqcjZe48o1h/9wfg)--