Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 70F4FB5DD0B for ; Fri, 15 Jul 2011 14:12:58 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 24797-02 for ; Fri, 15 Jul 2011 17:12:52 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 24A28B5DC63 for ; Fri, 15 Jul 2011 14:12:51 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id p6FHClkB003240; Fri, 15 Jul 2011 13:12:47 -0400 (EDT) To: Simon Riggs cc: David Ondrejik , pgsql-admin Subject: Re: vacuumdb question/problem In-reply-to: References: <4E206658.4040600@noaa.gov> Comments: In-reply-to Simon Riggs message dated "Fri, 15 Jul 2011 17:21:20 +0100" Date: Fri, 15 Jul 2011 13:12:47 -0400 Message-ID: <3239.1310749967@sss.pgh.pa.us> From: Tom Lane 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/115 X-Sequence-Number: 37894 Simon Riggs writes: > 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. That's possible, or it could be busy vacuuming some (really large?) index. Is the process actually busy, as in consuming CPU time according to top or other process monitoring tool? regards, tom lane