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