Re: getting estimated cost to agree with actual - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: getting estimated cost to agree with actual
Date
Msg-id dcc563d10806022006j3a1dc999t50039d0c9f74caff@mail.gmail.com
Whole thread Raw
In response to Re: getting estimated cost to agree with actual  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-performance
On Mon, Jun 2, 2008 at 7:20 PM, Gregory Stark <stark@enterprisedb.com> wrote:
> "Scott Marlowe" <scott.marlowe@gmail.com> writes:
>
>> On Mon, Jun 2, 2008 at 3:43 PM, Justin <justin@emproshunts.com> 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. :)

pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: getting estimated cost to agree with actual
Next
From: Marcin Citowicki
Date:
Subject: query performance question