| From: | Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com> |
|---|---|
| To: | preetika tyagi <preetikatyagi(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: query execution time |
| Date: | 2011-03-21 09:48:54 |
| Message-ID: | 603AF880-82C8-4CC7-A9E9-914A602A06DC@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-students |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Durumdara | 2011-03-21 10:22:43 | Linux, Hungarian charset (Win1250) is supports the hungarian collation? |
| Previous Message | Vibhor Kumar | 2011-03-21 09:43:13 | Re: Doubt in Backup |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zheng Yang | 2011-03-21 12:17:09 | foreign data wrappers |
| Previous Message | preetika tyagi | 2011-03-21 05:12:37 | query execution time |