Re: Is there a way to translate pg_amop.amopstrategy into a description? - Mailing list pgsql-general

From Morris de Oryx
Subject Re: Is there a way to translate pg_amop.amopstrategy into a description?
Date
Msg-id CAKqncchViX+ORtDEqxocN89ecMDZtSQ-31KmK30d=AQJcswPeA@mail.gmail.com
Whole thread Raw
In response to Re: Is there a way to translate pg_amop.amopstrategy into a description?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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@sss.pgh.pa.us> wrote:
Morris de Oryx <morrisdeoryx@gmail.com> 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

pgsql-general by date:

Previous
From: Koen De Groote
Date:
Subject: On a subscriber, why is last_msg_send_time in pg_stat_subscription sometimes null?
Next
From: Adrian Klaver
Date:
Subject: Re: On a subscriber, why is last_msg_send_time in pg_stat_subscription sometimes null?