From: Rajesh Kumar Mallah <mallah@trade-india.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Cc: joseph.turner@oakleynetworks.com
Subject: Re: Query becoming slower on adding a primary key [ SOLVED
Date: Fri, 11 Jun 2004 10:29:29 +0530
Message-ID: <40C93C31.6070404@trade-india.com> (raw)
In-Reply-To: <16609.1086125809@sss.pgh.pa.us>
References: <33303.192.168.0.100.1086117670.squirrel@system67.trade-india-local.com>
<16609.1086125809@sss.pgh.pa.us>
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
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah@trade-india.com, tgl@sss.pgh.pa.us, joseph.turner@oakleynetworks.com
Subject: Re: Query becoming slower on adding a primary key [ SOLVED
In-Reply-To: <40C93C31.6070404@trade-india.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox