From: Rajesh Kumar Mallah <mallah@trade-india.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org, "Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
Subject: Re: Why performance improvement on converting subselect to a function ?
Date: Wed, 30 Jul 2003 12:54:49 +0530
Message-ID: <200307301254.49159.mallah@trade-india.com> (raw)
In-Reply-To: <4578.1059514334@sss.pgh.pa.us>
References: <200307291114.29567.mallah@trade-india.com>
<3F26A503.3050104@trade-india.com>
<4578.1059514334@sss.pgh.pa.us>
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 what i mis(read|understood)
from there ;-) [ it was on GeneralBits' Home Page ]
Anyway the performance gain was from 32 secs to less
than a sec what i restored cache size from 64K to 1000.
I will post again with more details but at the moment
i got to load my data_bank :)
Regds
Mallah.
On Wednesday 30 Jul 2003 3:02 am, Tom Lane wrote:
> Rajesh Kumar Mallah <mallah@trade-india.com> 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 be the same plan. Curious that the runtime
> wasn't about the same. Perhaps the slow execution of the first query
> was a caching effect? If you alternate trying the query both ways,
> does the speed difference persist?
>
> regards, tom lane
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: mallah@trade-india.com, tgl@sss.pgh.pa.us, josh@agliodbs.com, shridhar_daithankar@persistent.co.in
Subject: Re: Why performance improvement on converting subselect to a function ?
In-Reply-To: <200307301254.49159.mallah@trade-india.com>
References: <200307291114.29567.mallah@trade-india.com> <3F26A503.3050104@trade-india.com> <4578.1059514334@sss.pgh.pa.us> <200307301254.49159.mallah@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