Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id B29701337CBC for ; Mon, 21 Mar 2011 17:34:57 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 90907-03 for ; Mon, 21 Mar 2011 20:34:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail5.sea5.speakeasy.net (mail5.sea5.speakeasy.net [69.17.117.49]) by mail.postgresql.org (Postfix) with ESMTP id E3D0B1337C35 for ; Mon, 21 Mar 2011 17:30:53 -0300 (ADT) Received: (qmail 4449 invoked from network); 21 Mar 2011 20:30:52 -0000 Received: from 25-76-42-72.skybeam.com (HELO [192.168.2.16]) (scott_ribe@killerbytes.com@[72.42.76.25]) (envelope-sender ) by mail5.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 21 Mar 2011 20:30:52 -0000 Subject: Re: query execution time Mime-Version: 1.0 (Apple Message framework v1082) Content-Type: text/plain; charset=us-ascii From: Scott Ribe In-Reply-To: Date: Mon, 21 Mar 2011 14:30:51 -0600 Cc: "pgsql-general@postgresql.org General" Content-Transfer-Encoding: quoted-printable Message-Id: References: <603AF880-82C8-4CC7-A9E9-914A602A06DC@enterprisedb.com> <376244CD-113E-4A82-A346-54D819B96947@elevated-dev.com> To: preetika tyagi X-Mailer: Apple Mail (2.1082) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201103/750 X-Sequence-Number: 174011 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. >=20 > 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. --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice