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 -- &
Thanks for any ideas. My experience has been that this happens sometimes
then the next reindexdb -a , everything reindexes fine.
Interest Rates NEAR 39yr LOWS! $430,000 Mortgage for $1,299/mo - Calculate
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2007-05-02 15:05:07|
|Subject: Re: strange buildfarm failures |
|Previous:||From: Alvaro Herrera||Date: 2007-05-02 14:26:26|
|Subject: Re: strange buildfarm failures|
pgsql-admin by date
|Next:||From: Keaton Adams||Date: 2007-05-02 14:58:48|
|Subject: A way to query last checkpoint record and WAL log through SQL?|
|Previous:||From: Michael Fuhr||Date: 2007-05-02 13:48:02|
|Subject: Re: pg_user pg_shadow out of sync|