> And what about commercial_entity.user_account_id. Is it indexed and what
> is its data type (i.e. does it match numeric(10,0))?

Yup - all columns in the statement are indexed, and they are all
numeric(10,0).

> Also, have you run VACUUM ANALYZE lately?

Yup - just before the last run.

Will get together my tuning data now.

David

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to