Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: The fastest way to update thousands of rows in moderately sized table - Mailing list pgsql-general

From 林士博
Subject Re: Re: The fastest way to update thousands of rows in moderately sized table
Date
Msg-id CACudzGj=dyNDdp_Q2PQutdZxyrDJW5pPF8izBcjqW_HPNzb7Lw@mail.gmail.com
Whole thread Raw
In response to Re: The fastest way to update thousands of rows in moderately sized table  (twoflower <standa.kurik@gmail.com>)
Responses Re: The fastest way to update thousands of rows in moderately sized table  (twoflower <standa.kurik@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: 林士博
Date:
Subject: Re: Using the database to validate data
Next
From: twoflower
Date:
Subject: Re: The fastest way to update thousands of rows in moderately sized table