Re: Query becoming slower on adding a primary key

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mallah(at)trade-india(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Query becoming slower on adding a primary key
Date: 2004-06-01 21:36:49
Message-ID: 16609.1086125809@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

mallah(at)trade-india(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Matthew Nuzum 2004-06-02 02:35:52 most efficient way to manage ordering
Previous Message mallah 2004-06-01 19:21:10 Query becoming slower on adding a primary key