On Thu, Jul 14, 2011 at 10:01, John R Pierce <pie...@hogranch.com> wrote:
> On 07/13/11 6:55 PM, Tony Wang wrote: > >> 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 > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general> >