Re: getting estimated cost to agree with actual

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: getting estimated cost to agree with actual
Дата
Msg-id dcc563d10806022006j3a1dc999t50039d0c9f74caff@mail.gmail.com
обсуждение исходный текст
Ответ на Re: getting estimated cost to agree with actual  (Gregory Stark <stark@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: getting estimated cost to agree with actual
Следующее
От: Marcin Citowicki
Дата:
Сообщение: query performance question