Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id F1C139FBD18; Wed, 2 May 2007 19:25:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 12771-09; Wed, 2 May 2007 19:24:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 5D8D89FBCE5; Wed, 2 May 2007 19:25:06 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l42MP4iZ022019; Wed, 2 May 2007 18:25:04 -0400 (EDT) To: "dx k9" cc: pgsql-admin@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: reindexdb hangs In-reply-to: References: Comments: In-reply-to "dx k9" message dated "Wed, 02 May 2007 11:49:14 -0400" Date: Wed, 02 May 2007 18:25:03 -0400 Message-ID: <22018.1178144703@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/31 X-Sequence-Number: 25351 "dx k9" writes: > [ stuck reindex ] > It turns out it was a temporary database and temporary table, that just > wasn't there maybe it thought it was there from some type of snapshot then > the next minute it was gone. Hmm, there is not any filter in ReindexDatabase() to exclude temp tables of other backends, but it sure seems like there needs to be. CLUSTER might have the same issue. I think we fixed this in VACUUM long ago, but we need to check the other commands that grovel over all of a database. regards, tom lane