Re: Hanging queries on dual CPU windows

Поиск
Список
Период
Сортировка
От Jan de Visser
Тема Re: Hanging queries on dual CPU windows
Дата
Msg-id 200603092100.27527.jdevisser@digitalfairway.com
обсуждение исходный текст
Ответ на Re: Hanging queries on dual CPU windows  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Thursday 09 March 2006 15:10, Tom Lane wrote:
> Is it possible to get a stack trace from the stuck process?  I dunno
> if you've got anything gdb-equivalent under Windows, but that's the
> first thing I'd be interested in ...

Here ya go:

http://www.devisser-siderius.com/stack1.jpg
http://www.devisser-siderius.com/stack2.jpg
http://www.devisser-siderius.com/stack3.jpg

There are three threads in the process. I guess thread 1 (stack1.jpg) is the
most interesting.

I also noted that cranking up concurrency in my app reproduces the problem in
about 4 minutes ;-)

With thanks to Magnus Hagander for the Process Explorer hint.

jan

--
--------------------------------------------------------------
Jan de Visser                     jdevisser@digitalfairway.com

                Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------

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

Предыдущее
От: Chris
Дата:
Сообщение: Re: pgCluster and postgres 8.1
Следующее
От: David Brown
Дата:
Сообщение: Re: firebird X postgresql 8.1.2 windows, performance comparison