Re: lock problem

From: Bèrto ëd Sèra <berto(dot)d(dot)sera(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: ruralhunter(at)gmail(dot)com, pgsql-admin(at)postgresql(dot)org
Subject: Re: lock problem
Date: 2011-12-21 13:51:14
Message-ID: CAKwGa_-C0Gcp2PaNWS9_kq0nz7KfcbV8hb5XYmxzUyHNt6AF-w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rural Hunter 2011-12-21 14:41:43 Re: lock problem
Previous Message Kevin Grittner 2011-12-21 13:28:10 Re: lock problem