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