Re: tune postgres for UPDATE

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Sebastian Böhm <seb(at)exse(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: tune postgres for UPDATE
Date: 2008-12-08 13:53:37
Message-ID: 2f4958ff0812080553h28dad31dg1636fb4113215882@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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;

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2008-12-08 13:53:56 Re: shared disk failover
Previous Message Stephane Bortzmeyer 2008-12-08 13:20:54 Re: Multi Lingual problem