Performance of "distinct with limit"

Поиск
Список
Период
Сортировка
От Klaudie Willis
Тема Performance of "distinct with limit"
Дата
Msg-id OWDKCDGTl83E-ZuJ_Y_UkyuwH9GBZBNyxoxRiQWddd1giuWoH5YHm9hWL08PTfNKfsqUgUsf_CG6TS4tAC3tM3gOeI2A5S0HVdj7Ko1dvoU=@protonmail.com
обсуждение исходный текст
Ответы Re: Performance of "distinct with limit"  (luis.roberto@siscobra.com.br)
Список pgsql-general
Hi,

Ran into this under-optimized query execution.

select distinct n from bigtable;   -- Lets say this takes 2 minutes
select distinct n from bigtable limit 2  -- This takes approximately the same time

However, the latter should have the potential to be so much quicker.  I checked the same query on MSSQL (with 'top 2'), and it seems to do exactly the optimization I would expect. 

Is there any way to achieve a similar speedup in Postgresql?

Klaudie



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

Предыдущее
От: Stelios Sfakianakis
Дата:
Сообщение: Re: Postgres and alias
Следующее
От: luis.roberto@siscobra.com.br
Дата:
Сообщение: Re: Performance of "distinct with limit"