Re: tune postgres for UPDATE - Mailing list pgsql-general

try rewriting it to something like:

update users set price = p.price from prices p where p.type =
'normal_price' and p.currency = users.currency;