Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 37C249FA182 for ; Thu, 14 Dec 2006 12:12:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 24357-09 for ; Thu, 14 Dec 2006 12:11:50 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id AF3719FA0EF for ; Thu, 14 Dec 2006 12:11:50 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kBEGBgXD021147; Thu, 14 Dec 2006 11:11:42 -0500 (EST) To: Evgeny Gridasov cc: pgsql-performance@postgresql.org Subject: Re: EXPLAIN ANALYZE on 8.2 In-reply-to: <20061214163230.d46f0138.eugrid@fpm.kubsu.ru> References: <20061214163230.d46f0138.eugrid@fpm.kubsu.ru> Comments: In-reply-to Evgeny Gridasov message dated "Thu, 14 Dec 2006 16:32:30 +0300" Date: Thu, 14 Dec 2006 11:11:42 -0500 Message-ID: <21146.1166112702@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/371 X-Sequence-Number: 22427 Evgeny Gridasov writes: > Running the same query on pg 8.2 through EXPLAIN ANALYZE takes 4x-10x time as running it without it. If your machine has slow gettimeofday() this is not surprising. 8.2 is no worse (or better) than any prior version. Some quick arithmetic from your results suggests that gettimeofday() is taking about 3.3 microseconds, which is indeed pretty awful. What sort of machine is this exactly? regards, tom lane