| 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:49:29 |
| Message-ID: | 20030204224929.12862.qmail@web40710.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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
---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patric Bechtel | 2003-02-04 22:52:12 | Re: UPDATE slow [Viruschecked] |
| Previous Message | John Smith | 2003-02-04 22:44:31 | Re: UPDATE slow |