Re: query execution time

Thank you, Vibhor!

I am wondering if caching will make such a big difference. For example, if A
is 15 minutes, then B is 1.5 hrs.
What could be other factors in case database server is separated from
clients (on different computer systems)?

Preetika

On Mon, Mar 21, 2011 at 2:48 AM, Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com
> wrote:

>
> On Mar 21, 2011, at 10:42 AM, preetika tyagi wrote:
>
> > Query: INSERT INTO table1 SELECT * FROM table2.
> > Execution Time: A ms.
> >
> > Query: INSERT INTO table1 SELECT * FROM table2.
> > Execution Time: B ms
>
> If session is same, then
> B < A if the data is cached due to execution of first statement.
> B > A, if the there is any change happened Or Any session has evicted the
> cached data.
>
> Thanks & Regards,
> Vibhor Kumar
> EnterpriseDB Corporation
> The Enterprise PostgreSQL Company
> vibhor(dot)kumar(at)enterprisedb(dot)com
> Blog:http://vibhork.blogspot.com
>
>