From: | Fabrice(dot)Sznajderman(at)devoteam(dot)com |
---|---|
To: | Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org, pgsql-jdbc-owner(at)postgresql(dot)org |
Subject: | Re: [IDLE in TRANSACTION] when I do TOP -c |
Date: | 2006-01-05 15:18:16 |
Message-ID: | OFDD6DDEE8.E87BE57C-ONC12570ED.0053BA7A-C12570ED.00544477@devoteam.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Thanks for your help!
I using WebSphere Portal Server to acces postgres database.
the Postgres Database is fill up by Redhat CCM - CMS.
So you think this message is not important for the database Performance?
Fabrice SZNAJDERMAN
DSI : Application Rendez-Vous - CCM
tel : 01 41 49 60 77
Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Envoyé par : pgsql-jdbc-owner(at)postgresql(dot)org
05/01/2006 17:15
A
Fabrice(dot)Sznajderman(at)devoteam(dot)com
cc
pgsql-jdbc(at)postgresql(dot)org
Objet
Re: [JDBC] [IDLE in TRANSACTION] when I do TOP -c
O Fabrice(dot)Sznajderman(at)devoteam(dot)com έγραψε στις Jan 5, 2006 :
> Hello,
>
>
> I look the processes on my server where was installed Postgres Database.
> I can saw, when I do top command, many process named : idle in
> transaction.
>
> What happend with this process? what is the cause of this message?
Maybe its some connection pool that causes this.
Have you installed and running jboss?? I know 3.x is behaving like that.
Generally its not a bad thing to worry about.
>
> Thanks in advance for your help,
>
> Fabrice
>
>
> +---------------------------------------------------------------------+
> About Devoteam:
>
> Devoteam is an IT consulting group.
> Combining consulting and technology solutions offers enables
> Devoteam to provide its customers with independent advice and
> effective solutions to align their information system's technical
> infrastructure with their operational objectives.
> The group achieved a turnover of 150 million euros in 2004
> an operating margin of 5.8% and counts 1,800 employees through
> ten European countries and the Middle East.
> Listed on the Euronext Paris Nouveau Marche and part of the Nexteconomy,
> IT CAC, IT CAC 50, SBF 250 index of Euronext Paris.
> www.devoteam.com
> +---------------------------------------------------------------------+
>
--
-Achilleus
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
From | Date | Subject | |
---|---|---|---|
Next Message | hpb@htl-steyr.ac.at | 2006-01-05 15:28:10 | Re: bug in getTime after insertRow with postgresql-8.1-404.jdbc3.jar |
Previous Message | Fabrice.Sznajderman | 2006-01-05 14:49:48 | [IDLE in TRANSACTION] when I do TOP -c |