"Francisco Reyes" <lists@stringsutils.com> writes:
> On 3:37 pm 07/23/08 Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> You might be more likely to get a sane plan if you had an index on
>> join_ids.customer_id.
> There is an index in join_ids:
> joinids_customerids_joinid" btree (customer_id, joinid) WITH (fillfactor=98)
[ squint... ] That makes no sense at all; it should certainly have
picked that index and not join_ids_join_id for a scan with a condition
on customer_id. What is the datatype of the customer_id column exactly?
(Actually, if you could show us the whole schema of both these tables,
such as their psql \d descriptions, that would be helpful.)
regards, tom lane