Search Postgresql Archives

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

Subject: Re: Re: The fastest way to update thousands of rows in moderately sized table
From: 林士博 <lin@xxxxxxxxxxxx>
Date: Fri, 24 Jul 2015 15:25:28 +0900
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <1437717115291-5859191.post@n5.nabble.com>

Sorry, my mistake.

Execution plan of an update sql seems always get rows=0.

Can you post execution plan of the original update sql.

EXPLAIN (ANALYZE ON, BUFFERS ON) update "TRANSLATION" set fk_assignmentwhere fk_job = 1000;

Follow-Ups:
- Re: The fastest way to update thousands of rows in moderately sized table
  - From: twoflower

References:
- The fastest way to update thousands of rows in moderately sized table
  - From: twoflower
- Re: The fastest way to update thousands of rows in moderately sized table
  - From: Adrian Klaver
- Re: The fastest way to update thousands of rows in moderately sized table
  - From: twoflower
- Re: Re: The fastest way to update thousands of rows in moderately sized table
  - From: 林士博
- Re: The fastest way to update thousands of rows in moderately sized table
  - From: twoflower