Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BD99A9FB6EA for ; Wed, 2 May 2007 11:50:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 57115-08 for ; Wed, 2 May 2007 11:50:14 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc3-s8.bay0.hotmail.com (bay0-omc3-s8.bay0.hotmail.com [65.54.246.208]) by postgresql.org (Postfix) with ESMTP id A1A689FB692 for ; Wed, 2 May 2007 11:50:14 -0300 (ADT) Received: from hotmail.com ([64.4.38.30]) by bay0-omc3-s8.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Wed, 2 May 2007 07:50:12 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 2 May 2007 07:50:12 -0700 Message-ID: Received: from 64.4.38.200 by by116fd.bay116.hotmail.msn.com with HTTP; Wed, 02 May 2007 14:50:09 GMT X-Originating-IP: [66.160.12.194] X-Originating-Email: [bitsandbytes88@hotmail.com] X-Sender: bitsandbytes88@hotmail.com From: "dx k9" To: pgsql-admin@postgresql.org Subject: reindexdb hangs Date: Wed, 02 May 2007 10:50:09 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 02 May 2007 14:50:12.0778 (UTC) FILETIME=[302AE0A0:01C78CC9] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.538 tagged_above=0 required=5 tests=AWL=0.371, BAYES_20=-0.74, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, MSGID_FROM_MTA_HEADER=0 X-Spam-Level: * X-Archive-Number: 200705/18 X-Sequence-Number: 25338 Hi, What would cause or what should I do with a table that hangs during its reindexing? I can see in the messages the last table to reindex, so sequentially the next table must be the problem. I have statement_timeout set for 6 hours, then I get "canceling statement due to statement timeout" Ok, that's fine, and I don't think setting the statement_timeout to 0 will really help. The question is why did it hang or what are some reasons that would make a table hang a reindexing? And is there a solution? At 1:45 AM the reindexing was going fine. Then, it just hung up -- & finally cancelled. Thanks for any ideas. My experience has been that this happens sometimes then the next reindexdb -a , everything reindexes fine. ~DJK _________________________________________________________________ Interest Rates NEAR 39yr LOWS! $430,000 Mortgage for $1,299/mo - Calculate new payment http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9632-19132&moid=14888