Postgres Pro
Downloads
Home   >   mailing lists

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

From twoflower
Subject Re: The fastest way to update thousands of rows in moderately sized table
Date
Msg-id 1437721091400-5859197.post@n5.nabble.com
Whole thread Raw
In response to Re: Re: The fastest way to update thousands of rows in moderately sized table  (林士博 <lin@repica.co.jp>)
Responses Re: Re: The fastest way to update thousands of rows in moderately sized table  (林士博 <lin@repica.co.jp>)
List pgsql-general
Tree view
林士博 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.

pgsql-general by date:

Previous
From: 林士博
Date:
Subject: Re: Re: The fastest way to update thousands of rows in moderately sized table
Next
From: 林士博
Date:
Subject: Re: Re: The fastest way to update thousands of rows in moderately sized table