Re: commit so slow program looks frozen

От: Carlo Stonebanks
Тема: Re: commit so slow program looks frozen
Дата: ,
Msg-id: ehqsev$18pc$1@news.hub.org
(см: обсуждение, исходный текст)
Ответ на: Re: commit so slow program looks frozen  ("Rocco Altier")
Список: pgsql-performance

Скрыть дерево обсуждения

commit so slow program looks frozen  ("Carlo Stonebanks", )
 Re: commit so slow program looks frozen  (Alvaro Herrera, )
 Re: commit so slow program looks frozen  ("Carlo Stonebanks", )
  Re: commit so slow program looks frozen  (Brian Hurt, )
  Re: commit so slow program looks frozen  (Scott Marlowe, )
   Re: commit so slow program looks frozen  ("Joshua D. Drake", )
   Re: commit so slow program looks frozen  ("Magnus Hagander", )
   Re: commit so slow program looks frozen  (Richard Troy, )
   Re: commit so slow program looks frozen  ("Carlo Stonebanks", )
    Re: commit so slow program looks frozen  ("Bucky Jordan", )
 Re: commit so slow program looks frozen  ("Carlo Stonebanks", )
  Re: commit so slow program looks frozen  ("Jim C. Nasby", )
 Re: commit so slow program looks frozen  ("Rocco Altier", )
  Re: commit so slow program looks frozen  ("Carlo Stonebanks", )
   Re: commit so slow program looks frozen  ("Merlin Moncure", )
    Re: commit so slow program looks frozen  ("Simon Riggs", )
     Re: commit so slow program looks frozen  ("Merlin Moncure", )
      Re: commit so slow program looks frozen  (Rob Lemley, )
   Re: commit so slow program looks frozen  (Richard Troy, )
    OT: TCL vs Perl Re: commit so slow program looks frozen  (, )
     Re: OT: TCL vs Perl Re: commit so slow program looks frozen  ("Joshua D. Drake", )
  Re: commit so slow program looks frozen  ("Carlo Stonebanks", )
  Re: commit so slow program looks frozen  ("Carlo Stonebanks", )
 Re: commit so slow program looks frozen  ("Carlo Stonebanks", )

> when it happens, make sure to query pg_locks and see what is going on
> there lock issues are not supposed to manifest on a commit, which
> releases locks, but you never know.

There aren't any pedning locks (assuming that pgAdmin is using pg_locks to
display pendin glocks).

> There have been reports of
> insonsistent lock ups on windows (espeically multi-processor) which
> you might be experiencing. Make sure you have the very latest version
> of pg 8.1.x.  Also consider checking out 8.2 and see if you can
> reproduce the behavior there...this will require compiling postgresql.

Are these associated with any type of CPU?

Carlo




В списке pgsql-performance по дате сообщения:

От: Tom Lane
Дата:
Сообщение: Re: query slows down drastically with increased number of fields
От: "Tom Darci"
Дата:
Сообщение: Re: query slows down drastically with increased number of