Re: Yet another question on LIMIT performance :/

Поиск
Список
Период
Сортировка
От Hannes Dorbath
Тема Re: Yet another question on LIMIT performance :/
Дата
Msg-id 454F44EF.1090401@theendofthetunnel.de
обсуждение исходный текст
Ответ на Re: Yet another question on LIMIT performance :/  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Список pgsql-performance
On 06.11.2006 15:13, Heikki Linnakangas wrote:
> Hannes Dorbath wrote:
>> Though it should only have to join a few rows it seems to scan all rows.
>
> What makes you think that's the case?

Sorry, not all rows, but 80753. It's not clear to me why this number is
so high with LIMIT 10.


--
Regards,
Hannes Dorbath

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Heikki Linnakangas"
Дата:
Сообщение: Re: Yet another question on LIMIT performance :/
Следующее
От: Madison Kelly
Дата:
Сообщение: Re: Setting "nice" values