X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7624932A4C8 for ; Mon, 11 Oct 2004 13:16:30 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89712-05 for ; Mon, 11 Oct 2004 12:16:20 +0000 (GMT) Received: from pw6tiger.de (pw6tiger.de [217.160.140.116]) by svr1.postgresql.org (Postfix) with SMTP id 5550632A3B8 for ; Mon, 11 Oct 2004 13:16:22 +0100 (BST) Received: (qmail 30577 invoked by uid 505); 11 Oct 2004 12:16:22 -0000 Received: from vygen@gmx.de by planwerk6 by uid 89 with qmail-scanner-1.14 (virus scan: Clear:. Processed in 0.139657 secs); 11 Oct 2004 12:16:22 -0000 Received: from isi-dial-146-203.isionline-dialin.de (HELO ?192.168.1.10?) (vygen@planwerk6.de@195.158.146.203) by pw6tiger.de with SMTP; 11 Oct 2004 12:16:22 -0000 From: Janning Vygen To: "Chris Hutchinson" Subject: Re: EXPLAIN ANALYZE much slower than running query normally Date: Mon, 11 Oct 2004 14:15:56 +0200 User-Agent: KMail/1.7 Cc: pgsql-performance@postgresql.org References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200410111415.56547.vygen@gmx.de> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/133 X-Sequence-Number: 8609 Am Dienstag, 5. Oktober 2004 08:49 schrieb Chris Hutchinson: > Running a trivial query in v7.4.2 (installed with fedora core2) using > EXPLAIN ANALYZE is taking considerably longer than just running the query > (2mins vs 6 secs). I was using this query to quickly compare a couple of > systems after installing a faster disk. > > Is this sort of slowdown to be expected? no. did you run VACCUM ANALYZE before? you should do it after pg_restore your db to a new filesystem in which order did you ran the queries. If you start your server and run two equal queries, the second one will be much faster because of some or even all data needed to answer the query is still in the shared buffers. janning