Re: Postgresql going to sleep?

>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:

    Tom> Raj Mathur <raju@linux-delhi.org> writes:
    >> 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.

    Tom> In that case, the backend is waiting for input from the
    Tom> client.

    Tom> If the client thinks it is waiting for the backend, I'd
    Tom> wonder about a missing "fflush" or something like that.  What
    Tom> client software are you using?

Using Perl 5.8.0 and DBI 1.32.  Any known problems with this setup?

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