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

<br /> HI,<br /><br /> The problem was solved by reducing the effective_cache_size from 102400 to 10240<br /> my total
RAMis 4GB.<br /><br /><br /> Regds<br /> mallah.<br /><br /> Tom Lane wrote: <blockquote
cite="mid16609.1086125809@sss.pgh.pa.us"type="cite"><pre wrap=""><a class="moz-txt-link-abbreviated"
href="mailto:mallah@trade-india.com">mallah@trade-india.com</a>writes: </pre><blockquote type="cite"><pre
wrap="">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  ;   </pre></blockquote><pre wrap=""> </pre><blockquote
type="cite"><prewrap="">Runs for Ever.   </pre></blockquote><pre wrap="">
 
So what does plain explain say about it?
        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              <a class="moz-txt-link-freetext"
href="http://archives.postgresql.org">http://archives.postgresql.org</a>
 </pre></blockquote><br />