Idle in transaction ????
| От | Steve Brett |
|---|---|
| Тема | Idle in transaction ???? |
| Дата | |
| Msg-id | 9su2ci$1h85$1@news.tht.net обсуждение |
| Ответы |
Re: Idle in transaction ????
|
| Список | pgsql-general |
we've just started using zeos postgresql db components in delphi and i've noticed that vacuum is hanging in postgres. if i do ps auxf i get the following postgres 332 0.0 0.5 13832 1344 ? S 14:24 0:00 /usr/local/pgsql/bin/./postmaster -i -o -F -B 1024 -N 128 postgres 722 0.0 1.3 14704 3496 ? S 14:55 0:00 \_ postgres: postgres ohm 10.139.13.112 idle in transact postgres 752 0.1 1.8 14580 4740 ? S 15:04 0:01 \_ postgres: iain ohm 10.139.13.187 idle postgres 1086 0.5 1.3 14620 3360 ? S 15:23 0:00 \_ postgres: postgres ohm [local] VACUUM waiting it's the 'idle in transact' that i'm puzzled about and i'm assuming it's idel within a transaction block ... can anyone help ??? Steve
В списке pgsql-general по дате отправления: