Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 28CE963316B for ; Tue, 17 Feb 2009 11:11:50 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 60741-03-5 for ; Tue, 17 Feb 2009 11:11:45 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mailsrv1.zmi.at (mailsrv1.zmi.at [212.69.162.198]) by mail.postgresql.org (Postfix) with ESMTP id 786016330FB for ; Tue, 17 Feb 2009 11:11:44 -0400 (AST) Received: from webmail.zmi.at (websrv1.zmi.at [212.69.162.199]) by mailsrv1.zmi.at (Postfix) with ESMTP id 140354059; Tue, 17 Feb 2009 16:11:41 +0100 (CET) Received: from phpmailer ([81.217.54.243]) by webmail.zmi.at with HTTP (PHPMailer); Tue, 17 Feb 2009 16:11:41 +0100 Date: Tue, 17 Feb 2009 16:11:41 +0100 To: Achilleas Mantzios , pgsql-admin@postgresql.org From: Michael Monnerie Subject: Re: 8.3.5 broken after power fail Message-ID: X-Priority: 3 X-Mailer: PHPMailer [version 1.71] X-Mailer: FeLaMiMail In-Reply-To: <200902171611.12655.achill@matrix.gatewaynet.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/118 X-Sequence-Number: 31339 "Achilleas Mantzios" schrieb: > did you reindex pg_toast_1281127? > take a look at=20 > http://archives.free.net.ph/message/20080924.191644.d692f468.el.html REINDEX TABLE pg_toast.pg_toast_1281127; That runs now since 33 CPU minutes, using 100% with no visible I/O happening. top says: 29687 postgres 20 0 605m 187m 3024 R 100 15.4 32:58.65 postmaster And "strace -p 29687" displays nothing. Could it be the process hangs? It shouldn't take that long I guess, but I'm not sure how to find out if it's borked or really working... ideas? mfg zmi