Re: getting estimated cost to agree with actual

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Jun 2, 2008 at 7:20 PM, Gregory Stark <stark@xxxxxxxxxxxxxxxx> wrote:
> "Scott Marlowe" <scott.marlowe@xxxxxxxxx> writes:
>
>> On Mon, Jun 2, 2008 at 3:43 PM, Justin <justin@xxxxxxxxxxxxxxx> 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. :)


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux