Postgres Pro
Downloads
Home   >   mailing lists

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

From 林士博
Subject Re: Re: The fastest way to update thousands of rows in moderately sized table
Date
Msg-id CACudzGjyBL7Z=xm9M6gDVLvZkLvKYkmo1t3Sh3=_0z364pB7Tg@mail.gmail.com
Whole thread Raw
In response to Re: The fastest way to update thousands of rows in moderately sized table  (twoflower <standa.kurik@gmail.com>)
Responses Re: The fastest way to update thousands of rows in moderately sized table  (twoflower <standa.kurik@gmail.com>)
List pgsql-general
Tree view
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;

pgsql-general by date:

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