Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AF7A79FB579 for ; Thu, 7 Jun 2007 10:54:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 76782-10 for ; Thu, 7 Jun 2007 10:54:31 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 54C879FB54A for ; Thu, 7 Jun 2007 10:54:40 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from hi-media.com (9.140-14-84.ripe.coltfrance.com [84.14.140.9]) by svr4.postgresql.org (Postfix) with ESMTP id 65BFB5AF8A5 for ; Thu, 7 Jun 2007 13:54:39 +0000 (GMT) Received: from dim (gut75-1-81-57-27-121.fbx.proxad.net [81.57.27.121]) by hi-media.com (Postfix) with ESMTP id 6578E188675 for ; Thu, 7 Jun 2007 15:54:10 +0200 (CEST) From: Dimitri Fontaine Organization: Hi-Media To: pgsql-performance@postgresql.org Subject: Re: {Spam} Re: Weird 8.2.4 performance Date: Thu, 7 Jun 2007 15:54:31 +0200 User-Agent: KMail/1.9.7 References: <371D1936-E96B-4865-AEEF-C82AC41C2982@hotdogrecords.com> <4667CE87.30101@archonet.com> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200706071554.31194.dfontaine@hi-media.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50=0.001, FORGED_RCVD_HELO=0.135 X-Spam-Level: X-Archive-Number: 200706/128 X-Sequence-Number: 25161 Le jeudi 07 juin 2007, Kurt Overberg a =E9crit=A0: > Is there a primer somewhere on how to read EXPLAIN output? Those Robert Treat slides are a great reading: http://www.postgresql.org/communityfiles/13.sxi Regards, =2D-=20 dim