Re: Comparitive UPDATE speed

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Comparitive UPDATE speed
Дата
Msg-id web-1736716@davinci.ethosmedia.com
обсуждение исходный текст
Ответ на Comparitive UPDATE speed  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
Randy,

> I'm not sure about 20 times longer but you would have index records
> that
> would need to be changed.  Is field_3 indexed in all 3 tables?  If
> table_b
> does not have an index on field_3 and the other tables do, I'd guess
> that
> would make this take longer too.

Yeah, they're indexed.   I'm going to try the updates without the index
on field_2 tonight.

-Josh Berkus

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Comparitive UPDATE speed
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Comparitive UPDATE speed