Re: Postgres gets stuck

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Re: Postgres gets stuck
Дата
Msg-id e3vl2r$k7$1@news.hub.org
обсуждение исходный текст
Ответ на Postgres gets stuck  ("Craig A. James" <cjames@modgraph-usa.com>)
Список 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 по дате отправления:

Предыдущее
От: Ketema Harris
Дата:
Сообщение: Nested Loops vs. Hash Joins or Merge Joins
Следующее
От: Greg Stark
Дата:
Сообщение: Re: [HACKERS] Big IN() clauses etc : feature proposal