pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (14+ messages)  latest in thread

Message-ID: <BAY116-F20D7467FFAFE69543B4C75D1420@phx.gbl>
Permalink:  ../BAY116-F20D7467FFAFE69543B4C75D1420@phx.gbl/
Also on:    postgresql.org/message-id/BAY116-F20D7467FFAFE69543B4C75D1420@phx.gbl

 · 

reply

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