From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Morris de Oryx <morrisdeoryx(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Is there a way to translate pg_amop.amopstrategy into a description? |
Date: | 2024-08-22 22:42:15 |
Message-ID: | 2087380.1724366535@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Morris de Oryx <morrisdeoryx(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2024-08-23 00:15:07 | Re: How to validate restore of backup? |
Previous Message | Morris de Oryx | 2024-08-22 22:34:39 | Is there a way to translate pg_amop.amopstrategy into a description? |