Postgres Pro
Downloads
Home   >   mailing lists

Re: query execution time - Mailing list pgsql-general

From Vibhor Kumar
Subject Re: query execution time
Date
Msg-id 603AF880-82C8-4CC7-A9E9-914A602A06DC@enterprisedb.com
Whole thread Raw
In response to query execution time  (preetika tyagi <preetikatyagi@gmail.com>)
Responses Re: query execution time  (preetika tyagi <preetikatyagi@gmail.com>)
List pgsql-general
Tree view 
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@enterprisedb.com
Blog:http://vibhork.blogspot.com

pgsql-general by date:

Previous
From: Vibhor Kumar
Date:
Subject: Re: Doubt in Backup
Next
From: Durumdara
Date:
Subject: Linux, Hungarian charset (Win1250) is supports the hungarian collation?