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 по дате отправления:

Предыдущее
От: John Smith
Дата:
Сообщение: Re: UPDATE slow
Следующее
От: "Patric Bechtel"
Дата:
Сообщение: Re: UPDATE slow [Viruschecked]