[local] idle in transaction

From: Chris Pizzo <chris(at)artinside(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: [local] idle in transaction
Date: 2003-06-19 19:56:25
Message-ID: 5.2.0.9.1.20030619155128.00a81d70@216.162.64.162
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,
Im finding a lot of "[local] idle in transaction" listings for postgres
when i ps -auwwx|grep postg

They are using memory and cpu time most are in the 20:00 time range. Is
this normal?

I am using mod_perl and I wonder if there are some scripts that aren't
disconnecting from the database.

Thanks for any help.

-Chris

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-06-19 22:17:02 Re: "Bad date external representation"
Previous Message Lynna Landstreet 2003-06-19 19:16:16 Re: "Bad date external representation"