Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
> Below are the plans for two cases. I dont know how to read them accurately
> can u please explain them.
Well, they're the same plan, as far as they go. I suppose that the
runtime difference must come from choosing a different plan inside the
most_
Tom Lane wrote:
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
What lead to degradation was the bumping off of
effective_cache_size parameter from 1000 to 64K
Check the plan then; AFAIR the only possible effect of changing
effective_cache_size is to influence which plan the planner picks.
On 30 Jul 2003 at 12:54, Rajesh Kumar Mallah wrote:
> Can any one point me the recent guide done by
> Sridhar and Josh i want to see what i mis(read|understood)
> from there ;-) [ it was on GeneralBits' Home Page ]
http://www.varlena.com/GeneralBits/Tidbits/perf.html
HTH
Bye
Shridhar
--
pr
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
> What lead to degradation was the bumping off of
> effective_cache_size parameter from 1000 to 64K
Check the plan then; AFAIR the only possible effect of changing
effective_cache_size is to influence which plan the planner picks.
Dear Tom,
the problem was repeatble in the sense repeated
execution of queries made no difference on
performance.
What lead to degradation was the bumping off of
effective_cache_size parameter from 1000 to 64K
Can any one point me the recent guide done by
Sridhar and Josh i want to see wha
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Odd. Apparently the planner is picking a better plan in the function
>> context than in the subselect context --- which is strange since it
>> ought to have less information.
> [ verbose plan snipped ]
Well, that sure seems to
Tom Lane wrote:
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
explain analyze SELECT company_id , (SELECT edition FROM ONLY
public.branding_master b WHERE old_company_id = a.company_id OR company_id =
a.company_id ORDER BY b.company_id DESC LIMIT 1) from public.branding_master
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
> explain analyze SELECT company_id , (SELECT edition FROM ONLY
> public.branding_master b WHERE old_company_id = a.company_id OR company_id =
> a.company_id ORDER BY b.company_id DESC LIMIT 1) from public.branding_master
> a limit 50;
> Total ru
Hi,
For each company_id in certain table i have to search the same table
get certain rows sort them and pick up the top one , i tried using this
subselect:
explain analyze SELECT company_id , (SELECT edition FROM ONLY
public.branding_master b WHERE old_company_id = a.company_id OR company_id =
