From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | GUCs to control abbreviated sort keys |
Date: | 2023-01-22 01:16:01 |
Message-ID: | d8454f6156956f5991cf9afd2f28978ed8187ca7.camel@j-davis.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
Attachment | Content-Type | Size |
---|---|---|
v1-0001-Introduce-GUCs-to-control-abbreviated-keys-sort-o.patch | text/x-patch | 8.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2023-01-22 02:37:59 | Re: Decoupling antiwraparound autovacuum from special rules around auto cancellation |
Previous Message | Jelte Fennema | 2023-01-21 23:39:25 | Re: run pgindent on a regular basis / scripted manner |