Thanks for the confirmation. And, I'd say that this feature would go under "nice to have" rather than anything more important. Although, it would be nice.
On Thu, Aug 22, 2024 at 5:42 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Morris de Oryx <morrisdeoryx@xxxxxxxxx> writes:
> What I'm hoping for is a function like
> get_opt_class_strategy_description(optclass, straregy_number) I've
> looked at the source a bit, and it seems that there is no such
> function, and that it might well be difficult to implement. The
> strategy numbers are, as far as I can see, local to the specific
> opt_class, which has no requirement to label them in any particular
> way.
That's correct. For btree and hash, the meanings of the strategy
numbers are determined by the index AM; but for (IIRC) all of our
other index AMs they're determined by the individual opclass. So
anything like this would have to be implemented by dedicated code
in each opclass. Perhaps that's worth doing, but it'd be a fair
amount of work.
regards, tom lane
