X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 4CD5AD1B23C
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 11 Jun 2004 02:05:37 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 15608-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 11 Jun 2004 05:05:32 +0000 (GMT)
Received: from trade-india.com (unknown [61.16.154.82])
	by svr1.postgresql.org (Postfix) with SMTP id 87639D1B20E
	for <pgsql-sql@postgresql.org>; Fri, 11 Jun 2004 02:05:23 -0300 (ADT)
Received: (qmail 19648 invoked from network); 11 Jun 2004 04:43:25 -0000
Received: from system100.trade-india-local.com (HELO ?192.168.0.100?)
	(192.168.0.100)
	by system66.trade-india-local.com with SMTP; 11 Jun 2004 04:43:25 -0000
Message-ID: <40C93C31.6070404@trade-india.com>
Date: Fri, 11 Jun 2004 10:29:29 +0530
From: Rajesh Kumar Mallah <mallah@trade-india.com>
Organization: Infocom Network Limited
User-Agent: Mozilla Thunderbird 0.6 (X11/20040502)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org, joseph.turner@oakleynetworks.com
Subject: Re: Query becoming slower on adding a primary key [ SOLVED
References: 
 <33303.192.168.0.100.1086117670.squirrel@system67.trade-india-local.com>
	<16609.1086125809@sss.pgh.pa.us>
In-Reply-To: <16609.1086125809@sss.pgh.pa.us>
Content-Type: multipart/alternative;
	boundary="------------000304020205060703040507"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.4 tagged_above=0.0 required=5.0 tests=HTML_30_40,
	HTML_MESSAGE, HTML_TITLE_EMPTY
X-Spam-Level: *
X-Archive-Number: 200406/95
X-Sequence-Number: 18040

This is a multi-part message in MIME format.
--------------000304020205060703040507
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit


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


--------------000304020205060703040507
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
HI,<br>
<br>
The problem was solved by reducing the effective_cache_size from 102400
to 10240<br>
my total RAM is 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">
    <pre wrap="">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>
</body>
</html>

--------------000304020205060703040507--