Re: Top-N sorts verses parallelism

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Top-N sorts verses parallelism
Дата
Msg-id CAMkU=1w6BJ5RJs0HxXi6K_jqVcUPYp0qz_8izeEF9AsGkAQSmg@mail.gmail.com
обсуждение исходный текст
Ответ на Top-N sorts verses parallelism  (Thomas Munro <thomas.munro@enterprisedb.com>)
Список pgsql-hackers
On Tue, Dec 12, 2017 at 10:46 PM, Thomas Munro <thomas.munro@enterprisedb.com> wrote:
Hi hackers,

The start-up cost of bounded (top-N) sorts is sensitive at the small
end of N, and the
comparison_cost * tuples * LOG2(2.0 * output_tuples) curve doesn't
seem to correspond to reality.


Do we want the cost-estimate to be accurate for the worst case (which is not terribly unlikely to happen, input order is opposite of desired output order), or for the average case?

Cheers,

Jeff

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Top-N sorts verses parallelism
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] Parallel Hash take II