Re: query execution time

[preetika tyagi <preetikatyagi@xxxxxxxxx>]

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.kumar@xxxxxxxxxxxxxxxx> 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.kumar@xxxxxxxxxxxxxxxx
Blog:http://vibhork.blogspot.com