On Mar 21, 2011, at 12:03 PM, preetika tyagi wrote: > I tried running the same query after reboot and back-to-back, it was taking less time in both the cases. It means the problem is something else. > > Can there be a reason which is more hardware/operating system specific and due to which the behavior is not uniform? While I do have a couple of ideas, you're probably better served by letting those here with more optimization experience help you, as their answers will be more complete. -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
