Re: bitmap scans, btree scans, and tid order

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: bitmap scans, btree scans, and tid order
Дата
Msg-id 42883F34.9050809@samurai.com
обсуждение исходный текст
Ответ на Re: bitmap scans, btree scans, and tid order  (Jeffrey Baker <jwbaker@acm.org>)
Ответы Re: bitmap scans, btree scans, and tid order  (Jeffrey Baker <jwbaker@acm.org>)
Список pgsql-hackers
Jeffrey Baker wrote:
> Would you take a patch that retained the optimized executions of plans 
> returning 1 tuple and also fixed the random heap problem?

Can you elaborate on what you're proposing? Obviously sorted b+-tree 
output is important for a lot more than just min()/max(). I don't see an 
obvious way to produce sorted output from a bitmap tree index scan 
without requiring an additional sort step (which would be rather 
pointless -- the whole point of the optimization is to avoid an 
additional sort).

-Neil


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

Предыдущее
От: Jeffrey Baker
Дата:
Сообщение: Re: bitmap scans, btree scans, and tid order
Следующее
От: Jeffrey Baker
Дата:
Сообщение: Re: bitmap scans, btree scans, and tid order