On Thu, Jul 14, 2011 at 10:01, John R Pierce <pierce@xxxxxxxxxxxx> wrote:
On 07/13/11 6:55 PM, Tony Wang wrote:i have postgres servers that run for months and even years without problems.
Could I consider it a hardware problem, or postgresql running too long which causes problems? (It ran about half a month, however, it ran much longer than that without problems)
Yeah, same for me.
based on what I see in your original posting, there's no way anyone on this list could possibly guess what is happening on your server.
Sorry but is there anything I'm missing? I just want to know any possible situation can cause high locks. The server runs for more than a year, and I didn't do any related update recently and it just happened.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
