Re: commit so slow program looks frozen

Поиск
Список
Период
Сортировка
От Carlo Stonebanks
Тема Re: commit so slow program looks frozen
Дата
Msg-id 036901c6f874$a907e700$6f05a8c0@Mars
обсуждение исходный текст
Ответ на commit so slow program looks frozen  ("Carlo Stonebanks" <stonec.register@sympatico.ca>)
Ответы Re: commit so slow program looks frozen  ("Jim C. Nasby" <jim@nasby.net>)
Список pgsql-performance

>> 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.

 

Carlo

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

Предыдущее
От: "Luke Lonergan"
Дата:
Сообщение: Re: Best COPY Performance
Следующее
От: "Mark Lonsdale"
Дата:
Сообщение: Configuration Issue ?