Re: Query becoming slower on adding a primary key [ SOLVED

HI,

The problem was solved by reducing the effective_cache_size from 102400
to 10240
my total RAM is 4GB.

Regds
mallah.

Tom Lane wrote:

>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
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>