Re: query execution time
| От | preetika tyagi |
|---|---|
| Тема | Re: query execution time |
| Дата | |
| Msg-id | AANLkTi=qu2L4YXnfvBPF2C5ZX8gCDfMTkfZgMd1mgwye@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: query execution time (Vibhor Kumar <vibhor.kumar@enterprisedb.com>) |
| Ответы |
Re: query execution time
|
| Список | pgsql-general |
Thank you, Vibhor!
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@enterprisedb.com> wrote:
If session is same, then
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
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 по дате отправления: