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)
i have postgres servers that run for months and even years 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