Re: lock problem - Mailing list pgsql-admin

From Bèrto ëd Sèra
Subject Re: lock problem
Date
Msg-id CAKwGa_-C0Gcp2PaNWS9_kq0nz7KfcbV8hb5XYmxzUyHNt6AF-w@mail.gmail.com
Whole thread Raw
In response to Re: lock problem  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: lock problem  (Rural Hunter <ruralhunter@gmail.com>)
List pgsql-admin
Hi!
 
I don't see a WHERE clause, so it looks like you're updating the
whole table each time.  

it's got a substr(pg_stat_activity.current_query,1,30) in it, so we shall hardly see anything about the WHERE clause, but we'd really need to have more info about it.

Bèrto
-- 
==============================
If Pac-Man had affected us as kids, we'd all be running around in a darkened room munching pills and listening to repetitive music.

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: lock problem
Next
From: Rural Hunter
Date:
Subject: Re: lock problem