Re: update ... from where id in (..) question - Mailing list pgsql-general

Feite Brekeveld <feite.brekeveld@osiris-it.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