Re: What's the fastest way to do this?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: What's the fastest way to do this?
Дата
Msg-id 19468.1005600507@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: What's the fastest way to do this?  (Orion <o2@trustcommerce.com>)
Список pgsql-general
Orion <o2@trustcommerce.com> writes:
> UPDATE test
>         SET description = x.description
>         FROM test AS rt, test_tmp AS x
>         WHERE rt.code = x.code;

This command is a three-way join between test AS test (the target),
test AS rt, and test_tmp AS x.  Almost certainly not what you want,
especially considering that the target table is not constrained at
all by the WHERE clause.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: What's the fastest way to do this?
Следующее
От: Frank Bax
Дата:
Сообщение: Re: 7.0.2 -> 7.1 performance drop