Re: selectivity function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Hennessy <greg(dot)hennessy(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: selectivity function
Date: 2022-05-26 21:54:21
Message-ID: 2460228.1653602061@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greg Hennessy <greg(dot)hennessy(at)gmail(dot)com> writes:
> On Thu, May 26, 2022 at 3:10 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Attaching a support function to a SQL-language function seems pretty
>> weird to me.

> Is there a way to set the selectivity of a SQL-language function?

I think it'd work if you prevented inlining, but doing so would defeat
most of the value of writing it as a SQL function as opposed to (say)
plpgsql. Can you do anything useful with attaching selectivity estimates
to the functions it references, instead?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2022-05-26 22:03:30 Re: pg_upgrade test writes to source directory
Previous Message Tom Lane 2022-05-26 21:50:40 Re: Remove support for Visual Studio 2013