Re: Odd new symptom - database locking up on a query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Odd new symptom - database locking up on a query
Дата
Msg-id 6349.1026015167@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Odd new symptom - database locking up on a query  (Doug Fields <dfields-pg-general@pexicom.com>)
Ответы Re: Odd new symptom - database locking up on a query  (Doug Fields <dfields-pg-general@pexicom.com>)
Список pgsql-general
Doug Fields <dfields-pg-general@pexicom.com> writes:
> At a certain point, a query hangs, then another, then another, until all my
> connections are blocked. My application completely comes to a halt.

Are they actually hung, or just taking an unreasonable amount of time?

Can you attach to some of the busy backends with gdb and get stack
traces?

            regards, tom lane



В списке pgsql-general по дате отправления:

Предыдущее
От: Doug Fields
Дата:
Сообщение: Re2: Odd new symptom - database locking up on a query
Следующее
От: Josh Jore
Дата:
Сообщение: Re: database backup