| From: | Raj Mathur <raju(at)linux-delhi(dot)org> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Postgresql going to sleep? |
| Date: | 2003-09-25 19:19:30 |
| Message-ID: | 16243.16322.159906.61824@mail.linux-delhi.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)kandalaya(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2003-09-25 19:57:27 | Re: [ADMIN] postgres 6.2 vacuum |
| Previous Message | Hornyak Laszlo | 2003-09-25 19:01:26 | invalid page header |