From: | Morris de Oryx <morrisdeoryx(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
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-23 14:36:21 |
Message-ID: | CAKqncchViX+ORtDEqxocN89ecMDZtSQ-31KmK30d=AQJcswPeA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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 15:02:56 | Re: On a subscriber, why is last_msg_send_time in pg_stat_subscription sometimes null? |
Previous Message | Koen De Groote | 2024-08-23 14:33:08 | On a subscriber, why is last_msg_send_time in pg_stat_subscription sometimes null? |