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

[twoflower <standa.kurik@xxxxxxxxx>]

林士博 wrote

Can you post execution plan of the original update sql. EXPLAIN (ANALYZE ON, BUFFERS ON) update "TRANSLATION" set fk_assignmentwhere fk_job = 1000;

Here it is:


Update on "TRANSLATION"  (cost=0.56..9645.13 rows=3113 width=391) (actual time=35091.036..35091.036 rows=0 loops=1)
    Buffers: shared hit=74842343 read=7242 dirtied=7513
      ->  Index Scan using "TRANSLATION_idx_composite_job_last_revision" on "TRANSLATION"  (cost=0.56..9645.13 rows=3113 width=391) (actual time=0.042..24.147 rows=8920 loops=1)
          Index Cond: (fk_job = 59004)
          Buffers: shared hit=626


Planning time: 0.362 ms
Execution time: 35091.192 ms

---

View this message in context: Re: The fastest way to update thousands of rows in moderately sized table
Sent from the PostgreSQL - general mailing list archive at Nabble.com.