Re: using sequential scan instead of index for join with a union

Hi, Sergei Thanks! I've just double checked and they are the same: \d notice id | bigint | | not null | nextval('notice_id_seq'::regclass) mbct_id| bigint | | | \d news id | bigint

Re: using sequential scan instead of index for join with a union

Hi Please check datatypes in union all part. Possible, notice.id or notice.mbct_id datatypes does not match with other tables. regards, Sergei