Re: commit so slow program looks frozen

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: commit so slow program looks frozen
Дата
Msg-id 20061026042150.GD26892@nasby.net
обсуждение исходный текст
Ответ на Re: commit so slow program looks frozen  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Список pgsql-performance
On Wed, Oct 25, 2006 at 04:32:16PM -0400, Carlo Stonebanks wrote:
> >> I have a question for you: did you have a long running query keeping open
> a transaction?  I've just noticed the same problem here, but things cleaned
> up immediately when I aborted the long-running transaction.
>
> No, the only processes are from those in the import applications themselves:
> short transactions never lasting more than a fraction of a second.

Do you have a linux/unix machine you could reproduce this on?
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Best COPY Performance
Следующее
От: Gavin Hamill
Дата:
Сообщение: VACUUMs take twice as long across all nodes