"Francisco Reyes" <[EMAIL PROTECTED]> writes:
> On 3:37 pm 07/23/08 Tom Lane <[EMAIL PROTECTED]> 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
