Re: UPDATE slow

From: John Smith <john_smith_45678(at)yahoo(dot)com>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: UPDATE slow
Date: 2003-02-04 22:44:31
Message-ID: 20030204224431.11898.qmail@web40710.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


It has two foreign key references to two other tables. No other tables reference stats though.
John
Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Smith 2003-02-04 22:49:29 Re: UPDATE slow
Previous Message Stephan Szabo 2003-02-04 22:40:35 Re: UPDATE slow