Re: Why is seq search preferred here by planner?

Mallah,

> Got it , you mean to say userid being pkey  is affecting the method of
> implicit join being made by the update  stmt.

More to the point, the PKey index doesn't help the db retrieve the rows to
join at all.  It might if only 1,000 rows matched, but not with 150,000
matching rows.

-Josh Berkus