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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
