"Scott Marlowe" <[EMAIL PROTECTED]> writes:
> On Fri, Sep 26, 2008 at 12:13 PM, Bill Thoen <[EMAIL PROTECTED]> wrote:
>> 2.) How can I make this update faster?
> Get a faster server?
Increasing work_mem might help. If the hashtable size estimate is
right, you'd need something like 100MB to be sure that the join gets
done in only one batch.
Also, if a lot of the rows needn't actually change, it'd be worthwhile
to add a WHERE clause:
UPDATE growers
SET grower_id = id2.grower_id
FROM id2 WHERE growers.fsa_id = id2.fsa_id
AND growers.grower_id != id2.grower_id
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
