Re: UPDATE slow
| От | John Smith |
|---|---|
| Тема | Re: UPDATE slow |
| Дата | |
| Msg-id | 20030204224929.12862.qmail@web40710.mail.yahoo.com обсуждение исходный текст |
| Ответ на | UPDATE slow (John Smith <john_smith_45678@yahoo.com>) |
| Ответы |
Re: UPDATE slow
|
| Список | 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 по дате отправления: