GUCs to control abbreviated sort keys

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

Responses

Browse pgsql-hackers by date

  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