Re: Postgres gets stuck - Mailing list pgsql-performance

From Qingqing Zhou
Subject Re: Postgres gets stuck
Date
Msg-id e3vl2r$k7$1@news.hub.org
Whole thread Raw
In response to Postgres gets stuck  ("Craig A. James" <cjames@modgraph-usa.com>)
List pgsql-performance
""Craig A. James"" <cjames@modgraph-usa.com> wrote
> I'm having a rare but deadly problem.  On our web servers, a process
> occasionally gets stuck, and can't be unstuck.  Once it's stuck, all
> Postgres activities cease.  "kill -9" is required to kill it --
> signals 2 and 15 don't work, and "/etc/init.d/postgresql stop" fails.
>
> Details:
>
>    Postgres 8.0.3
>

[Scanning 8.0.4 ~ 8.0.7 ...] Didn't find related bug fix in the upgrade
release. Can you attach to the problematic process and "bt" it (so we
could see where it stucks)?

Regards,
Qingqing



pgsql-performance by date:

Previous
From: Ketema Harris
Date:
Subject: Nested Loops vs. Hash Joins or Merge Joins
Next
From: Greg Stark
Date:
Subject: Re: [HACKERS] Big IN() clauses etc : feature proposal