From: | "dx k9" <bitsandbytes88(at)hotmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | reindexdb hangs |
Date: | 2007-05-02 14:50:09 |
Message-ID: | BAY116-F20D7467FFAFE69543B4C75D1420@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Keaton Adams | 2007-05-02 14:58:48 | A way to query last checkpoint record and WAL log through SQL? |
Previous Message | Michael Fuhr | 2007-05-02 13:48:02 | Re: pg_user pg_shadow out of sync |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-05-02 15:05:07 | Re: strange buildfarm failures |
Previous Message | Alvaro Herrera | 2007-05-02 14:26:26 | Re: strange buildfarm failures |