pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <smarlowe@g2switchworks.com>
To: dx k9 <bitsandbytes88@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: reindexdb hangs
Date: Wed, 02 May 2007 10:31:59 -0500
Message-ID: <1178119918.2953.5.camel@state.g2switchworks.com> (raw)
In-Reply-To: <BAY116-F20D7467FFAFE69543B4C75D1420@phx.gbl>
References: <BAY116-F20D7467FFAFE69543B4C75D1420@phx.gbl>

On Wed, 2007-05-02 at 09:50, dx k9 wrote:
> 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?

The real question is did it hang?  If the machine was still working on
reindexing then it wasn't hung, it was just taking longer than you
wanted it to.  Which can also be a problem, but isn't the same thing as
hanging, and as it's a different problem, would have a different
solution than if it is hanging.

So, what does vmstat / top / iostat have to say about this "hang"?  Was
it really hanging, or just taking a long time?



view thread (14+ messages)  latest in thread

Message-ID: <1178119918.2953.5.camel@state.g2switchworks.com>
Permalink:  ../1178119918.2953.5.camel@state.g2switchworks.com/
Also on:    postgresql.org/message-id/1178119918.2953.5.camel@state.g2switchworks.com

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: smarlowe@g2switchworks.com, bitsandbytes88@hotmail.com
  Subject: Re: reindexdb hangs
  In-Reply-To: <1178119918.2953.5.camel@state.g2switchworks.com>

* 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