Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 51E9A1336FA7 for ; Mon, 21 Mar 2011 13:06:45 -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 64095-08 for ; Mon, 21 Mar 2011 16:06:37 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail3.sea5.speakeasy.net (mail3.sea5.speakeasy.net [69.17.117.42]) by mail.postgresql.org (Postfix) with ESMTP id D4868133655C for ; Mon, 21 Mar 2011 13:06:36 -0300 (ADT) Received: (qmail 7700 invoked from network); 21 Mar 2011 16:06:35 -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 mail3.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted SMTP for ; 21 Mar 2011 16:06:35 -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 10:06:34 -0600 Cc: "pgsql-general@postgresql.org General" Content-Transfer-Encoding: quoted-printable Message-Id: <376244CD-113E-4A82-A346-54D819B96947@elevated-dev.com> References: <603AF880-82C8-4CC7-A9E9-914A602A06DC@enterprisedb.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/731 X-Sequence-Number: 173992 On Mar 21, 2011, at 9:55 AM, preetika tyagi wrote: > For example, if A is 15 minutes, then B is 1.5 hrs.=20 Well, considering that random disk access is on the order of 10,000 = times slower than RAM... But you can answer the question yourself by comparing the query run = against cold caches (after a reboot, or various command-line tricks to = purge cache) vs against warm caches (twice back-to-back). --=20 Scott Ribe scott_ribe@elevated-dev.com http://www.elevated-dev.com/ (303) 722-0567 voice