Feite Brekeveld <feite(dot)brekeveld(at)osiris-it(dot)nl> writes:
> I have a table with approx. 2mln records.
> There were a few for which I had to update statusfield, so I did:
> update table set statusflag = 'U' where id in ('id10', 'id20',
> 'id30');
> this took so long that I cancelled it, and used separate
> update table set statusflag = 'U' where id = 'id10';
> statements, which were executed in a fraction of a second.
What postgres version? What does EXPLAIN show for the two queries?
Have you VACUUM ANALYZEd that table recently?
regards, tom lane