Re: UPDATE slow [Viruschecked]

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: John Smith <john_smith_45678(at)yahoo(dot)com>
Cc: Patric Bechtel <bechtel(at)ipcon(dot)de>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: UPDATE slow [Viruschecked]
Date: 2003-02-04 23:11:36
Message-ID: Pine.LNX.4.33.0302041610590.6834-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-02-04 23:15:03 Re: Rules with "Where" Referencing Other Tables
Previous Message Stephan Szabo 2003-02-04 23:10:07 Re: UPDATE slow