PG_XLOG grows and grows

Поиск
Список
Период
Сортировка
От Niclas Gustafsson
Тема PG_XLOG grows and grows
Дата
Msg-id 005d01c1fc13$039689a0$b700a8c0@gmg
обсуждение исходный текст
Ответы Re: PG_XLOG grows and grows
Список pgsql-admin
Hi all, I have a little problem,

Every once in a while I observe that our filesystem is running out of
space due
to an continous growth of our transaction logs.
After inspecting the backend processes I see that three of the type:
idle in transaction.
And that all of our nightly vacuum runs since the "idle in transaction"
is waiting
with an: VACUUM waiting.

Is there any way of finding out exactly what the "idle in transaction"
transactions
have issued so far? What DB / logins etc. they are associated with?


Regards,

Niclas Gustafsson



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

Предыдущее
От: "Rajesh Kumar Mallah." (by way of Rajesh Kumar Mallah.
Дата:
Сообщение: Immortal backend .... (kill -9 ?..)
Следующее
От: "Nick Fankhauser"
Дата:
Сообщение: Re: [JDBC] Problem: upgrade from 7.1.3 to 7.2.1 ( database encode with ENC_TW)