GUCs to control abbreviated sort keys

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема GUCs to control abbreviated sort keys
Дата
Msg-id d8454f6156956f5991cf9afd2f28978ed8187ca7.camel@j-davis.com
обсуждение исходный текст
Ответы Re: GUCs to control abbreviated sort keys  (Justin Pryzby <pryzby@telsasoft.com>)
Re: GUCs to control abbreviated sort keys  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
The attached patch adds GUCs to control the use of the abbreviated keys
optimization when sorting. Also, I changed the TRUST_STRXFRM from a
#define into a GUC.

One reason for these GUCs is to make it easier to diagnose any issues
that come up with my collation work. Another is that I observed cases
with ICU where the abbreviated keys optimization resulted in a ~8-10%
regression, and it would be good to have some basic control over it.

I made them developer options because they are more about diagnosing
and I don't expect users to change these in production. If the issues
with abbreviated keys get more complex (where maybe we need to consider
costing each provider?), we can make it more user-facing.

This is fairly simple, so I plan to commit soon.

--
Jeff Davis
PostgreSQL Contributor Team - AWS



Вложения

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

Предыдущее
От: Jelte Fennema
Дата:
Сообщение: Re: run pgindent on a regular basis / scripted manner
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Decoupling antiwraparound autovacuum from special rules around auto cancellation