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>
Re: Comparitive UPDATE speed Ron Johnson <ron.l.johnson@cox.net>
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 по дате отправления
