Re: UPDATE slow [Viruschecked] - Mailing list pgsql-general

From scott.marlowe
Subject Re: UPDATE slow [Viruschecked]
Date
Msg-id Pine.LNX.4.33.0302041610590.6834-100000@css120.ihs.com
Whole thread Raw
In response to Re: UPDATE slow [Viruschecked]  (John Smith <john_smith_45678@yahoo.com>)
Responses Re: UPDATE slow [Viruschecked]  (John Smith <john_smith_45678@yahoo.com>)
List pgsql-general
Might we see your table schema?  This and the table(s) with the foreign
keys as well?

On Tue, 4 Feb 2003, John Smith wrote:

>
> No difference speed-wise:(. link_id is int4 (as is clicks). I also tried:
> update stats set clicks=3344::int4;
> and it still takes about the same amount of time (5-10 secs).
> John


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Rules with "Where" Referencing Other Tables
Next
From: John Smith
Date:
Subject: Re: UPDATE slow