Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id A81832E0053 for ; Tue, 3 Jun 2008 00:13:27 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 07435-08 for ; Tue, 3 Jun 2008 00:13:06 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.179]) by developer.postgresql.org (Postfix) with ESMTP id 4E4DC2E004D for ; Tue, 3 Jun 2008 00:06:21 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d37so776525pye.29 for ; Mon, 02 Jun 2008 20:06:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=nUDWK/i578E9HuRLj7Q8Aq5H8xEImA5LUdbXRGA5Q0M=; b=lvGxUGOetmxHgPotuXDaJClfBQt4/5zhzhETdaZc8Xz8T6h9/iHCGFeU68i/1vwhK1LyvsqGFVTy1EWgPumpmXnYbB79bEjdGX5yabCiP4UUlt5wy0L7rGM+3gXY1WcO5tNJZN6SulXW0qiVFSpiWvu1BnzCHbtTaVOSOkCnesw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=lZT3+//j0W6K96AYpPssvK6CVTvzItHwxLdlqbwIb3IIx9AAGOWq9A1e+cJKkyT6n8KYTLUNOR9APV7WLT+KovzQk4KHJORifX7D17YKXTD3Nm67HIUmukcZktokhdM9eZTco7CjsMewK7i1uQg5QPNhBxK8oCD41js17tWj8yM= Received: by 10.114.179.1 with SMTP id b1mr1497665waf.108.1212462380861; Mon, 02 Jun 2008 20:06:20 -0700 (PDT) Received: by 10.114.130.17 with HTTP; Mon, 2 Jun 2008 20:06:20 -0700 (PDT) Message-ID: Date: Mon, 2 Jun 2008 21:06:20 -0600 From: "Scott Marlowe" To: "Gregory Stark" Subject: Re: getting estimated cost to agree with actual Cc: Justin , pgsql-performance@postgresql.org In-Reply-To: <87mym3iab9.fsf@oxford.xeocode.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <4844696D.20307@emproshunts.com> <87mym3iab9.fsf@oxford.xeocode.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/7 X-Sequence-Number: 30357 On Mon, Jun 2, 2008 at 7:20 PM, Gregory Stark wrote: > "Scott Marlowe" writes: > >> On Mon, Jun 2, 2008 at 3:43 PM, Justin wrote: >>> >>> I have noticed that estimated Cost to do the query is way off from Actual. >> >> Well, they're not measured in the same units. estimated costs are in >> terms of the cost to sequentially scan a single tuple, while actual >> costs are in milliseconds. > > s/tuple/page/ Dangit! I knew that too. time for some sleep I guess. :)