Idle in transaction ????

From: "Steve Brett" <steve(dot)brett(at)e-mis(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Idle in transaction ????
Date: 2001-11-14 15:21:36
Message-ID: 9su2ci$1h85$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-11-14 15:37:21 Re: Memory exhausted in AllocSetReAlloc
Previous Message Andrew G. Hammond 2001-11-14 15:03:51 transitioning from MS SQL Server to Postgres