Re: An implementation of multi-key sort

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: An implementation of multi-key sort
Дата
Msg-id f8653c5a-4b1c-4c97-886e-db2a45993cc3@iki.fi
обсуждение исходный текст
Ответ на An implementation of multi-key sort  (Wang Yao <yaowangm@outlook.com>)
Ответы 回复: An implementation of multi-key sort
Список pgsql-hackers
On 22/05/2024 15:48, Wang Yao wrote:
> Comparing to classic quick sort, it can get significant performance
> improvement once multiple keys are available. A rough test shows it got
> ~129% improvement than qsort for ORDER BY on 6 keys, and ~52% for CREATE
> INDEX on the same data set. (See more details in section "Performance
> Test")

Impressive. Did you test the performance of the cases where MK-sort 
doesn't help, to check if there is a performance regression?

-- 
Heikki Linnakangas
Neon (https://neon.tech)




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

Предыдущее
От: "Euler Taveira"
Дата:
Сообщение: Re: speed up a logical replica setup
Следующее
От: Ranier Vilela
Дата:
Сообщение: Re: Avoid possible dereference null pointer (src/backend/catalog/pg_depend.c)