Postgres Pro
Downloads
Home   >   mailing lists

Postgresql going to sleep? - Mailing list pgsql-admin

From Raj Mathur
Subject Postgresql going to sleep?
Date
Msg-id 16243.16322.159906.61824@mail.linux-delhi.org
Whole thread Raw
Responses Re: Postgresql going to sleep?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
I'm consistently getting into a situation where the database client
just goes to sleep in a query after some number of queries in quick
succession. Using PostgreSQL 7.2.3 on Red Hat Linux 8.0.  The
postgres process shows up as ``idle in transaction'' in a ps.

Are there any tools I can use to figure out what's going on with the
client/server?  pgmonitor doesn't give any additional information
(except ``no query is being executed'').

Regards,

-- Raju
--
Raj Mathur                raju@kandalaya.org      http://kandalaya.org/
       GPG: 78D4 FC67 367F 40E2 0DD5  0FEF C968 D0EF CC68 D17F
                  All your domain are belong to us.
                      It is the mind that moves

pgsql-admin by date:

Previous
From: Hornyak Laszlo
Date:
Subject: invalid page header
Next
From: "Donald Fraser"
Date:
Subject: Case Insensitive Test