Re: [SQL] Long SQL Update Question

You can turn on logging ... but your transaction would be even slower after that. The following links should give you some pointers: http://www.postgresql.org/docs/8.1/static/monitoring-stats.html http://www.postgresql.org/docs/8.1/static/monitoring.html Also try Nagios monitoring plugins for Po

[SQL] Long SQL Update Question

So I kicked off a SQL transaction that has been running for 30+ minutes. Is there any way to monitor it to know if it has possibly hanged or not? To be fair, it is an update on 4+ million rows, so I expect it to run for a bit. But any stats or metrics I can get would be helpful. Cheers, dylan

Re: [SQL] Update question

PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gábriel Ákos Sent: Tuesday, March 28, 2006 12:34 PM To: pgsql-sql@postgresql.org Subject: Re: [SQL] Update question Markus Schaber wrote: > Hi, Fay, > > Fay Du wrote: >> Table cost >> >> Id edge_idcost >&

Re: [SQL] Update question

Markus Schaber wrote: Hi, Fay, Fay Du wrote: Table cost Id edge_idcost 1 30 101.4 2 30 null 3 40 500.2 4 40 null 545 300.7 645 null I want to set cost value with same edge_id by same value. T

Re: [SQL] Update question

Hi, Fay, Fay Du wrote: > Table cost > > Id edge_idcost > 1 30 101.4 > 2 30 null > 3 40 500.2 > 4 40 null > 545 300.7 > 645 null > I want to set cost value with same edge_id by same value. The exis

[SQL] Update question

Hi all:   I have a table like this:   Table cost Id  edge_id    cost 1   30 101.4 2   30  null 3   40  500.2 4   40   null 5    45  300.7 6    45   null   I want to set cost value with same edge_id by same

Re: [SQL] update question

Matthew Peter <[EMAIL PROTECTED]> writes: > it's in a loop so there's an extra comma at the end so i was thinking i > could put in a throw away value to keep the update from breaking if there's > an additional comma The best thing is to fix your loop logic. Usually it's not hard to emit a com

Re: [SQL] update question

On 12/5/05, Matthew Peter <[EMAIL PROTECTED]> wrote: > it's in a loop so there's an extra comma at the end so i was thinking i > could put in a throw away value to keep the update from breaking if there's > an additional comma > > Jaime Casanova <[EMAIL PROTECTED]> wrote: > On 12/5/05, Matthew Pete

Re: [SQL] update question

Like WHERE 1 = 1, but in UPDATE table SET value = 1, 1 = 1; Yahoo! Personals Single? There's someone we'd like you to meet. Lots of someones, actually. Try Yahoo! Personals

Re: [SQL] update question

it's in a loop so there's an extra comma at the end so i was thinking i could put in a throw away value to keep the update from breaking if there's an additional commaJaime Casanova <[EMAIL PROTECTED]> wrote: On 12/5/05, Matthew Peter wrote:> I need a throw away value for an insert statement...

Re: [SQL] update question

On 12/5/05, Matthew Peter <[EMAIL PROTECTED]> wrote: > I need a throw away value for an insert statement... example... > > update table > set value = 1, value = 2, throw_away_value -- so i don't break the query > where id = 1; > > Thanks > What do you mean by "throw away value"? are you trying to

[SQL] update question

I need a throw away value for an insert statement... example...update table set value = 1, value = 2, throw_away_value -- so i don't break the query where id = 1; Thanks Yahoo! Personals Let fate take it's course directly to your email. See who's waiting for you Yahoo! Personals