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

From: 林士博 <lin(at)repica(dot)co(dot)jp>
To: twoflower <standa(dot)kurik(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Re: The fastest way to update thousands of rows in moderately sized table
Date: 2015-07-24 06:25:28
Message-ID: CACudzGjyBL7Z=xm9M6gDVLvZkLvKYkmo1t3Sh3=_0z364pB7Tg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message twoflower 2015-07-24 06:58:11 Re: The fastest way to update thousands of rows in moderately sized table
Previous Message twoflower 2015-07-24 05:51:55 Re: The fastest way to update thousands of rows in moderately sized table