Re: Why is seq search preferred here by planner?

Mallah,

> UPDATE email_bank set country=personal_account_details.country where userid
> > 0 and userid=personal_account_details.userid ;

While Postgres is letting you "fudge", you are missing part of that SQL
statement. It should be:

UPDATE email_bank set country=personal_account_details.country
FROM personal_account_details
where userid > 0 and userid=personal_account_details.userid ;

> tradein_clients=# begin work;explain analyze UPDATE email_bank set
> country=personal_account_details.country where userid > 0 and
> userid=personal_account_details.userid ;BEGIN
> Time: 669.57 ms

Hmmm ... 669 ms seems pretty speedy for updating 150,000 rows. What's the
problem?

--
Josh Berkus
Aglio Database Solutions
San Francisco