From: | twoflower <standa(dot)kurik(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: The fastest way to update thousands of rows in moderately sized table |
Date: | 2015-07-24 06:58:11 |
Message-ID: | 1437721091400-5859197.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
林士博 wrote
> Can you post execution plan of the original update sql.EXPLAIN (ANALYZE
> ON, BUFFERS ON) update "TRANSLATION" setfk_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 msExecution time: 35091.192 ms
--
View this message in context: http://postgresql.nabble.com/The-fastest-way-to-update-thousands-of-rows-in-moderately-sized-table-tp5859144p5859197.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | 林士博 | 2015-07-24 08:04:10 | Re: Re: The fastest way to update thousands of rows in moderately sized table |
Previous Message | 林士博 | 2015-07-24 06:25:28 | Re: Re: The fastest way to update thousands of rows in moderately sized table |