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 05EB752A78 for ; Wed, 13 Jul 2005 17:20:31 -0300 (ADT) 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 55524-01 for ; Wed, 13 Jul 2005 20:20:26 +0000 (GMT) Received: from crestone.coronasolutions.com (crestone.coronasolutions.com [66.45.104.24]) by svr1.postgresql.org (Postfix) with ESMTP id 1D28552C9C for ; Wed, 13 Jul 2005 17:20:25 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by crestone.coronasolutions.com (Postfix) with ESMTP id 21AB36441AA for ; Wed, 13 Jul 2005 14:20:04 -0600 (MDT) Received: from crestone.coronasolutions.com ([127.0.0.1]) by localhost (crestone.coronasolutions.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29029-10 for ; Wed, 13 Jul 2005 14:20:02 -0600 (MDT) Received: from [192.168.1.100] (c-67-162-134-190.hsd1.co.comcast.net [67.162.134.190]) (using TLSv1 with cipher RC4-SHA (128/128 bits)) (No client certificate requested) by crestone.coronasolutions.com (Postfix) with ESMTP id 22206644195 for ; Wed, 13 Jul 2005 14:20:02 -0600 (MDT) Mime-Version: 1.0 (Apple Message framework v730) In-Reply-To: <20050713201715.GI24207@ns.snowman.net> References: <42D56772.6020408@arbash-meinel.com> <862C6AD9-646B-4907-AB18-09F1AD08B5F5@drivefaster.net> <20050713201715.GI24207@ns.snowman.net> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <7C8917ED-62B8-4D76-AC02-90CF04002C97@drivefaster.net> Content-Transfer-Encoding: 7bit From: Dan Harris Subject: Re: Quad Opteron stuck in the mud Date: Wed, 13 Jul 2005 14:20:24 -0600 To: pgsql-performance@postgresql.org X-Mailer: Apple Mail (2.730) X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at drivefaster.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200507/152 X-Sequence-Number: 13393 On Jul 13, 2005, at 2:17 PM, Stephen Frost wrote: > > Could you come up w/ a test case that others could reproduce where > explain isn't returning? This was simply due to my n00bness :) I had always been doing explain analyze, instead of just explain. Next time one of these queries comes up, I will be sure to do the explain without analyze. FYI that update query I mentioned in the initial thread just finished after updating 8.3 million rows. -Dan