INSERT/UPDATE waiting

From: Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com>
To: pgsql-sql(at)hub(dot)org
Subject: INSERT/UPDATE waiting
Date: 1999-05-04 09:33:34
Message-ID: 14126.48723.459657.7289@blanc.aeccom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hello,

somehow the backend is hanging on my system (6.5beta1, Linux 2.2.6):

postgres 29957 0.0 1.5 4124 2048 ? S 18:23 0:00 /usr/local/pgsql/bin/postgres localhost lutzeb cs UPDATE waiting
postgres 29980 0.0 1.6 4124 2064 ? S 18:25 0:00 /usr/local/pgsql/bin/postgres localhost lutzeb cs UPDATE waiting
postgres 30005 0.0 1.6 4124 2088 ? S 18:27 0:00 /usr/local/pgsql/bin/postgres localhost lutzeb cs UPDATE waiting
postgres 30012 0.0 2.1 4532 2696 ? S 18:28 0:00 /usr/local/pgsql/bin/postgres localhost lutzeb cs INSERT waiting
postgres 30030 0.0 3.0 5780 3916 ? S 18:28 0:00 /usr/local/pgsql/bin/postgres localhost lutzeb cs idle

[about 34 processes]

What is happening here? Can't find anything in the documentation.

Dirk

Browse pgsql-sql by date

  From Date Subject
Next Message Carlos Peralta Ramirez 1999-05-04 10:30:48 Help me please !!!!
Previous Message Richard Chrenko 1999-05-04 08:27:52 how to get "autonumber" when using INSERT INTO