Re: Query becoming slower on adding a primary key

mallah@trade-india.com writes:
> tradein_clients=# explain analyze select  email_id ,email ,contact from
> t_a a join email_source f using(email_id) join email_subscriptions h
> using(email_id) where 1=1 and f.source_id =1 and h.sub_id = 3  ;

> Runs for Ever.

So what does plain explain say about it?
        regards, tom lane