From: dx k9 <bitsandbytes88@hotmail.com>
To: pgsql-admin@postgresql.org
Subject: reindexdb hangs
Date: Wed, 02 May 2007 10:50:09 -0400
Message-ID: <BAY116-F20D7467FFAFE69543B4C75D1420@phx.gbl> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: bitsandbytes88@hotmail.com
Subject: Re: reindexdb hangs
In-Reply-To: <BAY116-F20D7467FFAFE69543B4C75D1420@phx.gbl>
References: <BAY116-F20D7467FFAFE69543B4C75D1420@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox