Re: Re: The fastest way to update thousands of rows in moderately sized table

Поиск
Список
Период
Сортировка
От 林士博
Тема Re: Re: The fastest way to update thousands of rows in moderately sized table
Дата
Msg-id CACudzGj=dyNDdp_Q2PQutdZxyrDJW5pPF8izBcjqW_HPNzb7Lw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: The fastest way to update thousands of rows in moderately sized table  (twoflower <standa.kurik@gmail.com>)
Ответы Re: The fastest way to update thousands of rows in moderately sized table  (twoflower <standa.kurik@gmail.com>)
Список pgsql-general
Дерево обсуждения
Try creating an index on TRANSLATION fk_job.

From the Execution plan you posted,
->(actual time=43262.266..43262.266 rows=0 loops=1)
actually, there is no row to be updated.

So, if you have a index on TRANSLATION fk_job, the update sql as behind should be finished within several seconds.
->update "TRANSLATION" set fk_assignmentwhere fk_job = 1000;

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

Предыдущее
От: 林士博
Дата:
Сообщение: Re: Using the database to validate data
Следующее
От: twoflower
Дата:
Сообщение: Re: The fastest way to update thousands of rows in moderately sized table