Odd behavior on update?

From: Dan Moschuk <dan(at)freebsd(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Odd behavior on update?
Date: 2000-10-13 17:01:29
Message-ID: 20001013130129.B10855@spirit.jaded.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


I'm trying to track down a source of great slowdown on our database, and
I seem to have become stuck.

If I issue the command...

c2net=> UPDATE url SET last_hit = 971456105 WHERE memid = 1;

This is all I see of it in my -d 2 window log.

query: UPDATE url SET last_hit = 971456105 WHERE memid = 1;
ProcessQuery

The query actually never completes. Eventually getting bored, I ^C the
client, and receive the message..

c2net=> UPDATE url SET last_hit = 971456105 WHERE memid = 1;
^CCancel request sent
ERROR: Query cancel requested while waiting lock

It seems to be stuck, as no longer how long I wait for this to become
unlocked, it never wants to become free.

Suggestions on where to go from here?

Thanks,
-Dan
--
Man is a rational animal who always loses his temper when he is called
upon to act in accordance with the dictates of reason.
-- Oscar Wilde

Browse pgsql-hackers by date

  From Date Subject
Next Message Ross J. Reedstrom 2000-10-13 19:11:19 Re: TIOGA
Previous Message Ross J. Reedstrom 2000-10-13 17:00:28 Re: [HACKERS] My new job