Re: UPDATE slow - Mailing list pgsql-general

From John Smith
Subject Re: UPDATE slow
Date
Msg-id 20030204224929.12862.qmail@web40710.mail.yahoo.com
Whole thread Raw
In response to UPDATE slow  (John Smith <john_smith_45678@yahoo.com>)
Responses Re: UPDATE slow  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general

I should also probably note that neither of the foreign key columns is being updated.

John

It has two foreign key references to two other tables. No other tables reference stats though.

John

 Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote:


On Tue, 4 Feb 2003, John Smith wrote:

> Just tried it on Linux - still takes 5-10 seconds. Any speed-up tips?
> Also tried it on MySQL and the update is nearly instantaneous :(.

Hmm, does stats reference another table or is it referenced by another
table?



Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now



Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

pgsql-general by date:

Previous
From: John Smith
Date:
Subject: Re: UPDATE slow
Next
From: "Patric Bechtel"
Date:
Subject: Re: UPDATE slow [Viruschecked]