Re: VACUUM is hanging

Поиск
Список
Период
Сортировка
От David Wall
Тема Re: VACUUM is hanging
Дата
Msg-id 008201c0d510$7615b120$5a2b7ad8@expertrade.com
обсуждение исходный текст
Ответ на VACUUM is hanging  (Ashley Clark <aclark@ghoti.org>)
Список pgsql-general
> Try not to leave open transactions hanging around in your Apache code.
> An idle database connection couldn't block VACUUM like that; it'd have
> to have been in the middle of a BEGIN block, or maybe even an unfinished
> query.

It's possible that the JDBC library always creates a new transaction after a
commit/rollback. It wouldn't have any locks or the like, though.

David



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

Предыдущее
От: Ashley Clark
Дата:
Сообщение: Re: VACUUM is hanging
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Re: VACUUM is hanging